= '%s' order by title",
mysql_real_escape_string($page["title"])
));
$nextpage = mysql_fetch_assoc($resultForNext );
$nextpage = mysql_fetch_assoc($resultForNext );
$resultForPrevious = mysql_query(sprintf(
"select * from gallery where title < '%s' order by title desc",
mysql_real_escape_string($page["title"])
));
$previouspage = mysql_fetch_assoc($resultForPrevious);
$result = mysql_query(sprintf("select * from images where gallery_id = %d order by sequence", $page["id"]));
while ($row = mysql_fetch_assoc($result)) {
$images[] = $row;
}
$category_list = array(
"Bars & Restaurants" => "/archive/BarsRestaurants.php",
"Airports" => "/archive/Airports.php",
"Business" => "/archive/Business.php",
"Hotels" => "/archive/Hotels.php",
"Cool Installations" => "/archive/CoolInstallations.php",
"Vessels" => "/archive/Vessels.php",
"National Parks" => "/archive/NationalParks.php",
"Landmarks" => "/archive/NationalParks.php",
"Private Residence" => "/archive/PrivateResidence.php",
"Sporting & Concert Venues" => "/archive/SportingConcertVenues.php",
"Museums" => "/archive/Museums.php",
"Eductional Institutions" => "/archive/EductionalInstitutions.php",
"Public" => "/archive/Public.php",
"Women's" => "/archive/Womens.php",
"Miscellaneous" => "/archive/Miscellaneous.php"
);
$category_titles = array(
"Airports" => "Airports, Train Stations, Sea Ports",
"Hotels" => "Hotels & Casinos",
"National Parks" => "Parks",
"Cool Installations" => "Top 1,000 Urinals",
"Public" => "Public Facilities",
"Educational Institutions" => "Schools and Universities",
"Private Residences" => "Private Residences",
"Sporting & Concert Venues" => "Sporting, Concert, and Other Venues",
"Women's" => "Women's Installations"
);
function title($page) {
if ($page["extended_title"]) {
return $page["title"];
} else {
return "The Urinals of " . $page["title"];
}
}
?>
<?php print strip_tags(title($page)) ?>
');">
\n",
$image["src"], $image["width"], $image["height"]);
printf("%s
\n", $image["comment"]);
}
$total_image_height = 0;
foreach ($images as $image) {
draw_image($image);
$total_image_height += $image["height"];
}
?>