<?php
require("db_credentials.php");

$db = @mysql_connect($db_host,$db_name,$db_passwd) or die ("MySQL error");
@mysql_select_db($db_database,$db) or die ("MySQL error");

$result = mysql_query(
  "SELECT markers.*,users.login FROM markers ".
  "LEFT JOIN users ON markers.ownerid=users.id WHERE public=1", $db);

if (result !== FALSE) {
  while ($data = @mysql_fetch_assoc($result))
    $res[] = $data;

  echo json_encode($res);
}
?>