require "vars.php"; $content = ""; if(isset($_GET['id'])) { $id = $_GET['id']; if(isset($_GET['category'])) { $category = $_GET['category']; $result = mysql_query("SELECT * FROM $mysql_pictures_c WHERE id = '$category' LIMIT 1"); $title = mysql_result($result, 0, 'category'); $result = mysql_query("SELECT * FROM $mysql_pictures WHERE category = '$category' ORDER BY `added` DESC"); $cp = "category=$category"; $cp_ = "of $title"; } elseif(isset($_GET['place'])) { $place = $_GET['place']; $result = mysql_query("SELECT * FROM $mysql_pictures_p WHERE id = '$place' LIMIT 1"); $title = mysql_result($result, 0, 'place'); $result = mysql_query("SELECT * FROM $mysql_pictures WHERE place = '$place' ORDER BY `added` DESC"); $cp = "place=$place"; $cp_ = "of $title"; } if(isset($cp)) { $num_rows = mysql_num_rows($result); for($x = 0; $x < $num_rows; $x++) { if(mysql_result($result, $x, "id") == $id) { if($x == 0) $prev_pic_link = "Previous"; else $prev_pic_link = "Previous"; if($x == $num_rows - 1) $next_pic_link = "Next"; else $next_pic_link = "Next"; break; } } $content .= "
$prev_pic_link | $next_pic_link $cp_
"; } $result = mysql_query("SELECT * FROM $mysql_pictures p, $mysql_pictures_c pc, $mysql_pictures_p pp WHERE p.id = '$id' AND pc.id = p.category AND pp.id = p.place LIMIT 1"); $description = mysql_result($result, 0, 'p.description'); $date = mysql_result($result, 0, 'p.date'); $pc_id = mysql_result($result, 0, 'pc.id'); $pp_id = mysql_result($result, 0, 'pp.id'); $content .= "$description
Photographed: ".makedate($date)."
"; } $replace[0] = ""; $replaces[0] = $content; echo makefile("template.php", $replace, $replaces); ?>