<?php
$link =  mysql_connect('localhost', 'd6_guifitest', 'guifinet');
if (!$link) {
    die('No pudo conectarse: ' . mysql_error());
}
echo 'Conectado  satisfactoriamente';

if (!mysql_select_db('d6_guifitest')) {
    die('Could not select database: ' . mysql_error());
}

$query = "SELECT * FROM guifi_location where zone_id='11031'";

$result = mysql_query($query);
if (!$result) {
    die('Could not query:' . mysql_error());
}

while ($row = mysql_fetch_assoc($result)) {
    echo $row['nick'].$row['lat'].$row['lon']."<br>";
}

mysql_close($link);
?>