$mysql="select * from names";
$mysql_result=mysql_query($mysql, $connection);
$num_rows=mysql_num_rows($mysql_result);
if ($num_rows == 0) {
echo "sorry there is no information);
}else {
while ($row=mysql_fetch_array($mysql_result))
{
// line 30
$name=$row["name"];
$town=$row["town"];
echo "<tr><td>$name</td><td>$town</td></tr>";
}
}=end else
mysql_close($connection);
?>