|
Louisiana State University,Baton Rouge, LA 70803, USA +1 (225) 578-5241
|
|
Search Alphabeticaly by Last Name
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
Search By Graduation Year
}
showform();
$Last = $_GET['last'];
$First = $_GET['first'];
$Middle = $_GET['middle'];
if ($Last != '')
{
$username = "alum";
$password = "alumdata";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
$selected = mysql_select_db("Alumni",$dbh) or die("Could not select alumni");
$result = mysql_query("SELECT FirstName, MiddleName, LastName, DegreeYear, Email, TellUsStuff FROM Alumni WHERE LastName LIKE '$Last%' AND FIRSTNAME LIKE '$First%'AND MIDDLENAME LIKE '$Middle%' ORDER BY LastName");
writeheader();
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$First = $row[0];
$Middle = $row[1];
if ($Middle == '0'){
$Middle = '';
}
$Last = $row[2];
$DegreeYear = $row[3];
$Email = $row[4];
$Tell = $row[5];
if ($Email == '0'){
writetable2($First, $Middle, $Last, $DegreeYear, $Email, $Tell);
}
elseif($Email != '0'){
writetable($First, $Middle, $Last, $DegreeYear, $Email, $Tell);
}
}
mysql_close($dbh);
} //if
?>
|
Return to ECE Alumni Main Site
|