Portail PHP

$link = opendb();

$query = doquery("SELECT latitude,longitude FROM rpg_towns WHERE id='$id' LIMIT 1", "towns");
$query = doquery("SELECT latitude,longitude FROM rpg_users WHERE id='$id' LIMIT 1", "users");

$pos = "SELECT latitude,longitude FROM rpg_users WHERE id='$id'";
$query = mysql_query($pos);
$tabl = mysql_fetch_array($query);


$lat = $tabl['latitude'];
$long = $tabl['longitude'];
$latmax = $lat + 9;
$longmax = $long + 9;
$latmin = $lat - 9;
$longmin = $long - 9;


$latitude = $latmin;
echo "<table width="100%" border="1">"; 
while ($latitude <= $latmax ) {
echo "<tr>";
$longitude = $longmin;
while ($longitude <= $longmax) {
$sql = "SELECT username, avatar FROM rpg_users WHERE latitude='$latitude' AND longitude='$longitude'";
$query = mysql_query($sql);
$fetch = mysql_fetch_array($query);
$username = $fetch['username'];
$avatar = $fetch['avatar'];

$sqll = "SELECT name FROM rpg_towns WHERE latitude='$latitude' AND longitude='$longitude'";
$query = mysql_query($sqll);
$fetch = mysql_fetch_array($query);
$villes = $fetch['name'];

echo "<td>".$villes."&nbsp;".$username."&nbsp;".$avatar."&nbsp;</td>";

$longitude++;
}
echo "</tr>";
$latitude++;
}
echo "</table>";
?>

$latmax = $lat + 9;
$longmax = $long + 9;
$latmin = $lat - 9;
$longmin = $long - 9;