Click on the Thumbnail to view a larger image.
0) {
$start = (($page * 20) - 20);
}
else {
$start = 0;
}
$sqlCount = "select * from ppt, imageRelease
where imageRelease.imageReleaseLive = 'yes'
and imageRelease.imageReleaseYear = $pageYear
and imageRelease.imageReleaseID = ppt.imageReleaseID";
$resultsCount = mysqli_query($conn, $sqlCount);
$numRecords = mysqli_num_rows($resultsCount);
//print $numRecords;
$numPage = ceil($numRecords/20);
if ($numPage < 1) {
$numPage = 1;
}
$sqlPPT = "select * from ppt, imageRelease
where imageRelease.imageReleaseLive = 'yes'
and imageRelease.imageReleaseYear = $pageYear
and imageRelease.imageReleaseID = ppt.imageReleaseID
order by imageRelease.imageReleaseFullDate desc
limit $start, 20";
$resultPPT = mysqli_query($conn, $sqlPPT) or die("query failed ppt");
$numRecords = mysqli_num_rows($resultPPT);
$count = 1;
print "
Page ";
for ($n=1; $n <= $numPage; $n++) {
$pageNumber = $n;
if (!$page) { $page = 1; }
if ($page == $pageNumber) {
$bgColor = "#cccccc";
}
else {
$bgColor = "none";
}
print "".$pageNumber."";
$pageNumber++;
}
print "
";
$img_count = 0;
?>
\n";
}
++$img_count;
print "\n";
if ($img_count == 5) {
print "
\n";
}
else {
print "
\n";
}
$count++;
}
?>
\n";
}
print "![\"".$name."\"](\"/photo/".$year."/".$dirName."/".$imagePrefix."_115.jpg\")
\n";
print "
\n"; print "".$count." ".$name; print "
\n"; print "PowerPoint\n"; print "
\n"; print "PDF\n"; print "
\n"; print "[Photo Album]\n"; echo "
\n";
if($img_count==5) {
$img_count=0;
print "![\"".$name."\"](\"/photo/".$year."/".$dirName."/".$imagePrefix.".jpg\")
\n"; print "".$count." ".$name; print "
\n"; print "PowerPoint\n"; print "
\n"; print "PDF\n"; print "
\n"; print "[Photo Album]\n"; echo "