Use the form below to search member biographies or search the entire Hall of Fame site
if ($member_search!=""){
//connecting to database
include("../include/inc_db_connection.php");
include("../include/inc_queries.php");
$search_database = search_database($member_search);
$result = mysql_query($search_database, $connection);
unset($records_array);
unset($i);
$records_array = array();
$i=0;
while ($row = mysql_fetch_array($result)){
$records_array[$i]["member_id"] = $row[0];
$records_array[$i]["member_name"] = $row[1];
$records_array[$i]["member_title"] = $row[2];
$i++;
};
//declaring number of rows to output
$row_output = 20;
//declaring output counter
if (!$start_point || $start_point==""){
$start_point=0;
};
$start_next = $start_point + $row_output;
$start_back = $start_point - $row_output;
print("
Search results for: $member_search");
//back and next buttons
if ($start_next > $row_output){
print("
<< Previous");
};
//output counter
if (count($records_array)!=0){
if (($start_point + $row_output) > count($records_array)){
print(" Records ". ($start_point+1) ." - ".count($records_array)." out of " . count($records_array)." ");
}else{
print(" Records ". ($start_point+1) ." - ".$start_next." out of " . count($records_array)." ");
};
};
if ($start_next < count($records_array)){
print("
Next >>");
};
//starting output
print("
");
//selecting records for the output
if (($start_point + $row_output) > count($records_array)){
$end_point = count($records_array);
}else{
$end_point = $start_point + $row_output;
};
if ($i!=0){
//outputting columns
for($j=$start_point; $j < $end_point; $j++){
print("- ".$records_array[$j]["member_name"]."
");
print("".$records_array[$j]["member_title"]." ");
};
}else{
print("No results found.");
};
unset($records_array);
//finishing output
print("
");
};
?>