 |
 |
McDonald's
Corporate Honoree
|
|
 |
Rance Crain
Crain Communications, Advertising Age |
|
 |
Bob Giraldi
Giraldi Media, Film Director |
|
 |
Philip H. Knight
NIKE, Inc.
|
|
 |
Shelly Lazarus
Ogilvy & Mather
|
|
 |
Byron E. Lewis Sr.
UniWorld Group, Inc.
|
|
 |
Gerry Rubin
RPA
|
|
 |
Bob Scarpelli
DDB Worldwide
|
|
|
 |
|
Search alphabetically:
A | B | C |
D | E | F |
G | H | I |
J | K | L |
M | N | O |
P | Q | R |
S | T | U |
V | W | X |
Y | Z | All
|
|
Search by year of induction:
|
|
//here we are working with cases
//if year exist, we have to run one query and html output
//if letter, it will be another and another HTML output
//if nothing, we have to show a message
if ($uyear!=""){
if ($uyear=="all"){
$year_start = "1940";
$year_end = "2009";
}else{
$year_start = $uyear;
$year_end = $uyear+9;
};
//getting all years for the provided time
$get_years = get_years($year_start,$year_end);
$result = mysql_query($get_years, $connection);
while($row = mysql_fetch_array($result)){
$induction_year = $row[0];
print("$induction_year ");
//now we need to find and output all members for this year
$search_by_year = search_by_year($induction_year);
$result2 = mysql_query($search_by_year, $connection);
//index to check how many records was found
$i = 0;
while($row2 = mysql_fetch_array($result2)){
$i++;
$member_id_year = $row2[0];
$member_name_year = $row2[1];
print(" $member_name_year ");
if ($i==4){
print(" ");
$i=0;
};
};
//closing TR tag
print(" | | ");
};
}else{
if ($uflag=="all"){
//getting all members in alfabetical order
$get_all_letters = get_all_letters();
$result = mysql_query($get_all_letters, $connection);
while($row = mysql_fetch_array($result)){
$all_letter = $row[0];
print("$all_letter ");
$i = 0;
$search_by_lname = search_by_lname($all_letter);
$result2 = mysql_query($search_by_lname, $connection);
while($row2 = mysql_fetch_array($result2)){
$i++;
$member_id_year = $row2[0];
$member_name_year = $row2[1];
print(" $member_name_year ");
if ($i==4){
print(" ");
$i=0;
};
};
print(" | | ");
};
}else{
if ($uflag!=""){
//working with letters
//declaring search leter
$lname = strtoupper($uflag);
print("$lname ");
//index to check how many records was found
$i = 0;
$j = 0;
$search_by_lname = search_by_lname($uflag);
$result = mysql_query($search_by_lname, $connection);
while($row = mysql_fetch_array($result)){
$i++;
$j++;
$member_id_year = $row[0];
$member_name_year = $row[1];
print(" $member_name_year ");
if ($i==4){
print(" ");
$i=0;
};
};
if ($j==0){
print("No results were found");
};
print(" | | ");
}else{
//nothing exist
print("No results were found");
print(" | | ");
};
};
};
?>
|