Return to Main
First Name
Middle
Initial
Last
Initial
Member ID
(click to view their WonderList)
include("conn.php"); $query = "SELECT fname, minitial, lname, member_id FROM member order by fname, lname"; $result = mysql_db_query($db, $query); while ($r = mysql_fetch_array($result)) { $fname = $r["fname"]; $minitial = $r["minitial"]; if ($minitial == "") {$minitial = " ";} $lname = $r["lname"]; if ($lname == "") { $lname = " "; } else { $lname = substr($lname,0,1); } $m_id = $r["member_id"]; echo "
$fname
$minitial
$lname
$m_id
"; } mysql_free_result($result); ?>