<?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);
while ($data=@mysql_fetch_assoc($result))
  $res[]=$data;
echo json_encode($res);
?>