include 'dbselect.php';
$x = $HTTP_GET_VARS['px'];
$y = $HTTP_GET_VARS['py'];
if ($x=="" and $y=="") {
echo '';
echo 'Please select a point form the map or double click to upload new photo(s)! | ';
echo '
';} else {
$query = "SELECT `ID`,`X`,`Y`,`PHOTO`,`NAME`,`RAITING`,`COMMENTS`,`APP_TXT` FROM `plovdiv` WHERE `x`='$x' AND `y`='$y' AND `APP`='1'";
$result = mysql_query($query) or die("Query failed");
while($line = mysql_fetch_assoc($result)) {
//echo"id:".$line["ID"]."
";
//echo"x:".$line["X"]."
";
//echo"y:".$line["Y"]."
";
echo '';
echo '';
echo' ';
echo $line["NAME"];
echo" | ";
echo '
';
//echo"rating:".$line["RATING"]."
";
//if ($line["APP_TXT"]=="1") { echo"comments:"."
".$line["COMMENTS"]."
";}
$id=$line["ID"];
}
// echo 'x='.$x.' y='.$y.' ____';
echo '-------------
Add photo at the same location.
| ';
mysql_close($link);
}
?>