include("config.php");
$link = mysql_connect($mysql_host, $mysql_user, $mysql_pass)
or die("Could not connect");
mysql_select_db($mysql_table)
or die("Could not select database");
$result = mysql_query("SELECT * FROM users ORDER BY id;")
or die("falseDatabase error #1.");
if ($result) {
$aantal_users = mysql_num_rows($result);
if ($aantal_users>0) {
echo "";
echo "true";
echo "";
for ($i=0; $i<$aantal_users ; $i++) {
$user = mysql_fetch_object($result);
echo "
$user->name
$user->color
";
$result2 = mysql_query("SELECT * FROM points WHERE userid='$user->id' ORDER BY id;")
or die("falseDatabase error #1.");
$aantal_points = mysql_num_rows($result2);
for ($j=0; $j<$aantal_points ; $j++) {
$point = mysql_fetch_object($result2);
echo "
$point->lat
$point->lon
$point->date
$point->descr
";
}
echo("
");
}
echo "
";
echo "";
} else {
echo "false";
echo "No data in DB.";
}
} else {
echo "false";
echo "Could not connect to DB.";
}
?>