0) ) {
$sql = "select gallery_id, name, description, map_center_lat, map_center_long, map_zoom_level from gallery where gallery_id=".$_GET["galleryId"];
$res = mysql_query($sql,$my_conn);
$gallery = mysql_fetch_assoc($res);
$sql="
SELECT p.photo_id, p.filename, p.description, p.latitude, p.longitude, c.camera_folder_name
FROM photo p, photo_to_gallery ptg, camera c
WHERE ptg.gallery_id=".$gallery["gallery_id"]."
AND p.photo_id=ptg.photo_id
AND p.public=1
AND c.camera_id = p.camera_id
ORDER BY p.filename, p.photo_id
";
// die($sql);
$res = mysql_query($sql,$my_conn);
$photo_count = 0;
while ($db_image = mysql_fetch_object($res)) {
$exifimage = $_SESSION["lowres_path"].$db_image->camera_folder_name.$db_image->filename;
$thumbimage = $_SESSION["thumbnail_path"].$db_image->camera_folder_name.$db_image->filename;
$imagehref = "/image.php?from=map&ga=".$_GET["galleryId"]."&im=".$db_image->photo_id;
if (file_exists($exifimage)) $exif_data_available = true;
if ( ($exif_data_available) && (isset($db_image->latitude)) && (isset($db_image->longitude)) ) {
?>