include('global.php'); include('navigation.php'); $queryString = "catId=$_GET[catId]"; if ( $_GET['photoNr'] == -1 ) { header( 'location: category.php?catId=' . $_GET['catId'] ); exit; } if ($login) { $sql = "SELECT photoId, photoCatId, photoTitle, photoBy, photoCamera, photoText, photoDate, photoLocation, photoClicks, ROUND((photoClicks / (TO_DAYS(CURDATE()) - TO_DAYS(photoDateAdded))), 1) AS clicksPerDay, catName FROM photos INNER JOIN categories ON photoCatId = catId WHERE photoCatId = $_GET[catId] ORDER BY photoOrder, photoId DESC LIMIT $_GET[photoNr], 1"; } else { $sql = "SELECT photoId, photoCatId, photoTitle, photoBy, photoCamera, photoText, photoDate, photoLocation, catName FROM photos INNER JOIN categories ON photoCatId = catId WHERE photoCatId = $_GET[catId] ORDER BY photoOrder, photoId DESC LIMIT $_GET[photoNr], 1"; } //die( $sql ); $rsPhoto = mysql_query($sql, $conn) or die(mysql_error()); $rowPhoto = mysql_fetch_assoc($rsPhoto); if (!mysql_num_rows($rsPhoto)) header("location: category.php?$queryString"); $sql = "SELECT c2.catId, c2.catName, c2.catBelow FROM categories AS c1, categories AS c2 WHERE c1.catId = $_GET[catId] AND c2.catBelow = c1.catBelow ORDER BY c1.catOrder, c1.catName"; $rsSubCats = mysql_query($sql, $conn) or die(mysql_error()); $rowSubCats = mysql_fetch_assoc($rsSubCats); $mainCat = $rowSubCats[catBelow]; include('navigation.php'); // Click toevoegen if (!in_array($_SERVER['REMOTE_ADDR'], $myIp) and !$login) { $sql = "UPDATE photos SET photoClicks = photoClicks + 1 WHERE photoId = $rowPhoto[photoId]"; mysql_query($sql, $conn); } $sql = "SELECT COUNT(photoId) AS totalPhotos FROM photos WHERE photoCatId = $_GET[catId] GROUP BY photoCatId"; $rsCount = mysql_query($sql, $conn); $imagePath = "data/$rowPhoto[photoId].jpg"; $imageSize = @getimagesize($imagePath); $imageWidth = $imageSize[0]; $imageHeight = $imageSize[1]; echo page_headers(html, "$rowPhoto[catName] - PP3", 'global, navigation, photo'); ?>
echo $navigation; echo"$rowPhoto[photoText]
\n" : "\n"; ?>
![]() |
![]() |