NOW() - INTERVAL 30 MINUTE ORDER BY dtime DESC LIMIT 1;"); if (mysqli_num_rows($q) > 0){ $r = mysqli_fetch_array($q); echo("1\n"); echo("$r[lat]\n"); echo("$r[lon]\n"); echo("$r[username]\n"); echo("$r[dtime]\n"); echo("$r[manual]\n"); echo("$r[action]\n"); } else{ echo("0\n"); } ?>