// table stuff

$database=mysql_connect("localhost","root");

mysql_select_db("contacts",$database);

$SQL="SELECT * FROM people";
mysql_query("SELECT * FROM cities INNER JOIN people ON people.cityid = cities.id") or die(mysql_error());

$result=mysql_query($SQL);

$num_results=mysql_num_rows($result);

echo "<table border='1'>
<tr>
<th>ID</th>
<th>First name</th>
<th>Last name</th>
<th>Age</th>
<th>Gender</th>
<th>Email</th>
<th>City ID</th>

</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['first_name'] . "</td>";
echo "<td>" . $row['last_name'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td>" . $row['gender'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td>" . $row['name'] . "</td>";


echo "</tr>";
}
echo "</table>";







}