");?>

0 AND Surname Like '$surname' AND Given_Name Like '$firstname' ORDER BY Given_Name"; $sql_countresult = mysql_query($sqlcount, $connection) or die ("Couldn't execute query"); $totalrows = mysql_num_rows($sql_countresult); ?> 0 AND Surname Like '$surname' AND Given_Name Like '$firstname' ORDER BY Given_Name LIMIT $limitvalue1, $limit"; $sql_result = mysql_query($sql, $connection) or die ("Couldn't execute query"); ?>

");?>

         Primary Subject -        Source -
Residence at Record -        Reference Page -        Census Family Number -
Age at Record -        Date of Birth -        Place of Birth -        Age at Marriage -
Spouse -        Recorded Marriage Date -        Marriage Location -
Date of Death -               Date of Burial -
Cemetery -        Age on Gravestone -          Grave Designation -
Occupation -        Veteran -        Military Unit -
Father's Name -        Father's Place of Birth -
Mother's Name -        Mother's Place of Birth -
Notes -

"; if($page != 1) { $pageprev= $page - 1; echo " PREV "; // if page is not equal to one, prev goes to $page - 1 } else { echo " PREV "; // Otherwise, PREV reloads the page } $numofpages = $totalrows/$limit; for($i= 1; $i < $numofpages; $i++) { echo " $i "; // make number navigation } if($totalrows%$limit != 0) { echo " $i "; // if there is a remainder, add another page } if(($totalrows-($limit*$page)) > 0){ $pagenext = $page + 1; echo " NEXT "; // if the totalrows - $limit * $page is > 0 (meaning there is a remainder), leave the next button. } mysql_free_result($sql_result); mysql_close($connection); ?>