'.$sql);
//print($sql);
$numrec=mysql_fetch_row ($result);
$numpage=intval($numrec[0]/$found_limit);
if ($numrec[0]%$found_limit)$numpage++; // add one page if remainder
if(!is_numeric($page) || $page>$numpage || $page<1)$page=1;
$offset=($page-1)*$found_limit;
$sql="
SELECT
gravestone.*,CT_Name,cemName
FROM
gravestone
INNER JOIN
countylist on CID=CountyID
INNER JOIN
cemeteries on cemID=cemeteryID and cemCID=CID
$wheretext
limit $offset,$found_limit
";
$result = mysql_query($sql) or die(mysql_error().'
'.$sql);
$db_txt="
";
$db_txt.="This is tempoarary debuging information, please disregard, unless you are having
problems.
";
$db_txt.="$sql";
$db_txt.="
";
if($search=="custom"){
?>
0)
echo("Records placed in the trash will be deleted 10 days after their last update.
");
if($search=="recent"){
?>
Goto Page: ");
if($pg_start>1)echo("First ");
for ($count=$pg_start;$count<=$total;$count++) { // loop thru
if ($count < (10+$pg_start)) $iMod = 1;
elseif ($count < (50+$pg_start)) $iMod = 10;
else $iMod=50;
if ($count % $iMod==0){
if($count!=$page){
print "$count \n";
} else {
print "$count \n";
}
$pg_last=$count;
}
}
if($pg_last<$total)echo(" Last");
echo("");
}
if($numpage>1)PageIndex($page,$numpage,"index.php?days_old={$_REQUEST['days_old']}&page=");
?>
- Record(s) Found
| $NoneFoundMsg | ");
} else {
$rmIconName="Delete";
if($search=="trash")$rmIconName="Restore";
?>
| |
Name |
Location |
County |
Status |
Uploaded |
|
Hold";
if($row["approved"]=='Y')$status="Approved";
if($row["approved"]=='D')$status="Pending Removal";
if(stristr($row["first"],"Cemetery")){
$name=strtoupper($row["last"]." ".$row["first"]);
if(strlen($name)>25)$name=substr($name,0,23).'...';
$name.=" 
";
} else {
$name=strtoupper($row["last"]).", ".$row["first"];
if(strlen($name)>25)$name=substr($name,0,23).'...';
}
if($row["photoURL"]!=$lastURL && $row["groupid"]!=0){
$lastURL=$row["photoURL"];
$grpToggle=1-$grpToggle;
$newGroup=true;
}
if($grpToggle==0){
$grpBack="bgcolor='#dddddd'";
} else {
$grpBack="bgcolor='#999999'";
}
if(!$show_group || $row["groupid"]==0)$grpBack=$back;
?>
 |
 |
 |
0)echo(" ");?> |
|
|
|
|
|
");
} else {
if($grpBack==$back){
echo(" | ");
} else {
echo(" | ");
}
}
?>
Key:
- Edit/Approve |
- Public Preview |
- Group Indicator