Search
$lastinit=$_GET['lastinit'];
include "dbconfig.php";
?>
Search Results: print date ("D, d M Y H:i:s");?> Pacific
Click on name to see Profile
if( ! isset($offset)){
$offset=0;
}
if(! isset($numrecords)){
$query = "SELECT COUNT(id_number) AS total FROM members";
$result=mysqli_query($con, $query);
echo mysqli_error($con);
$total = mysqli_num_rows($result);
}
#$displaynumber=5;
$query = "SELECT id_number, suffix, lastname, middlename, firstname FROM members WHERE lastname like '$lastinit%' and (status ='A' or status = 'E') ORDER BY lastname, firstname limit $offset, 300";
#printf("%s",$query);
$result=mysqli_query($con, $query);
# $color="ccccff";
while($row = mysqli_fetch_array($result))
{
# if ($color == "ccccff") $color = "ffcccc";
# else $color = "ccccff";
$id_number=stripslashes($row['id_number']);
$lastname=stripslashes($row['lastname']);
$middlename=stripslashes($row['middlename']);
$firstname=stripslashes($row['firstname']);
$suffix=stripslashes($row['suffix']);
printf("%s %s, %s %s
\n",$id_number, $lastname,$suffix, $firstname, $middlename);
#printf("%s
",$byline);
}
mysqli_close($con);
printf("
");
?>
/*
if($offset != 0)
{
printf("[Previous 20] \n",$id_number, $offset-20, $numrecords);
}
$offset += 20;
if($offset < $numrecords){
printf("[Next 20]\n",$id_number, $offset, $numrecords);
}
*/
?>