"; $cnt = 0; $type = array( "plain" => '_', "lake" => '~', "sea" => '~', "mountain" => 'M', "plateau" => '-', "forest" => 'T' , "desert" => 'W', "jungle" => 'T' ); $q = "SELECT * FROM ". $table . " WHERE x < " . ($x+10) . " AND x > " . ($x-10) . " AND y < " . ($y+10) . " AND y > " . ($y-10) . " ORDER BY y ASC, x ASC"; $data = mysql_query($q); while($tile = mysql_fetch_array($data)) { if ($cnt == 19) { $cnt = 0; echo "
"; } $cnt += 1; if (($tile['x'] < ($x-5)) || ($tile['x'] > ($x+5)) || ($tile['y'] < ($y-5)) || ($tile['y'] > ($y+5))) { echo "" . $type[$tile['type']] . ""; } elseif (($tile['x'] == $x) && ($tile['y'] == $y)) { echo "" . 0 . ""; } else { echo "" . $type[$tile['type']] . ""; } } /*end*/ mysql_close($con); ?>