////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//BEGIN DEVELOPMENT CLASS
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function getPhotosWithFavsOlder($tableName, $fieldName, $recordNum, $perPage){
$getNumPhotosQ = "SELECT * FROM `cms_uploads` WHERE `tableName` = '$tableName' AND `recordNum` = '$recordNum'";
$getNumPhotosR = mysql_query($getNumPhotosQ);
$getNumPhotosNR = mysql_num_rows($getNumPhotosR);
if(isset($_GET['page'])){
$page = $_GET['page'];
}else{
$page = 1;
}
$startLimit = $page * $perPage - $perPage;
$finishLimit = $page * $perPage;
$limit = $startLimit.','.$perPage;
$getPhotosQ = "SELECT * FROM `cms_uploads` WHERE `tableName` = '$tableName' AND `fieldName` = '$fieldName' AND `recordNum` = '$recordNum' ";
if(isset($_GET['favs'])){
$getPhotosQ .= "AND `info5` = '1' ";
}
$getPhotosQ .= "ORDER BY `order`";
if(!isset($_GET['favs'])){
$getPhotosQ .= " LIMIT $limit";
}
//echo $getPhotosQ;
$getPhotosR = mysql_query($getPhotosQ);
//echo $getPhotosQ;
if(!isset($_GET['favs'])){
$pagination = '';
if(isset($_GET['page'])){
$currPage = $_GET['page'];
if($_GET['page'] != 1){
$prevPage = $_GET['page'] -1;
$pagination .= '
<< prev';
}else{
$pagination .= '<< prev';
}
}else{
$currPage = 1;
$pagination .= '<< prev';
}
$numPages = ceil($getNumPhotosNR/$perPage);
$pagination .= ' - page '.$currPage.' of '.$numPages.' - ';
if(isset($_GET['page'])){
if($_GET['page'] < $numPages){
$nextPage = $_GET['page'] + 1;
$pagination .= '
next >>';
}else{
$pagination .= 'next >>';
}
}else{
$pagination .= '
next >>';
}
}
echo '
';
echo '
';
echo '
';
$getNumFavsQ = "SELECT `num` FROM `cms_uploads` WHERE `tableName` = '$tableName' AND `fieldName` = '$fieldName' AND `recordNum` = '$recordNum' AND `info5` = '1'";
$getNumFavsR = mysql_query($getNumFavsQ);
$getNumFavsNR = mysql_num_rows($getNumFavsR);
if(isset($_GET['favs'])){
echo '
';
}else{
echo '
';
}
if(!isset($_GET['favs'])){
echo '';
}
echo '
';
while($photos = mysql_fetch_assoc($getPhotosR)){
$thisfilename = fileName($photos['urlPath']);
if($photos['info5'] > 0){
$savedChecked = ' CHECKED';
}else{
$savedChecked = '';
}
if(isset($_GET['favs'])){
$detailBoxClass = 'detailBox2';
$detailImageClass = 'detailImage2';
$img = '
![View Larger Image '.$photos['info1'].']('.$photos['thumbUrlPath2'].')
';
$underimagefilename = '
'.$thisfilename.'
';
}else{
$detailBoxClass = 'detailBox2';
$detailImageClass = 'detailImage2';
$img = '
![View Larger Image '.$photos['info1'].']('.$photos['thumbUrlPath2'].')
';
$underimagefilename = '
';
}
echo <<
';
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//END DEVELOPMENT CLASS
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
?>