include "inc/config.inc.php"; include "inc/header.php"; // fill out the headers do_headers($strSurnameIndex); $name=$_GET["id"]; ?> // make a list of people $squery = "SELECT person_id, name, surname, suffix, DATE_FORMAT(date_of_birth, ".$datefmt.") AS DOB, DATE_FORMAT(date_of_death, ".$datefmt.") AS DOD FROM ".$tblprefix."people"; if ($_SESSION["id"] == 0){ $squery .= " WHERE surname = '$name' AND date_of_birth < '$restrictdate' ORDER BY name ASC"; }else{ $squery .= " WHERE surname = '$name' ORDER BY name ASC";} $sresult = mysql_query($squery) or die($err_person); echo'
Persons Name |
".$srow["name"]." ".$srow["suffix"]." (".formatdate($srow["DOB"])." - ".formatdate($srow["DOD"])."): |