if ($_GET["submitted"])
{
mysql_pconnect("localhost","rhay","AmazonDesert");
$fields = array ("lname", "fname", "class", "email");
$query = "SELECT ".implode (",", $fields)." FROM members\n".
"WHERE lname LIKE '".AddSlashes($_GET["letter"])."%' ORDER BY lname";
$result = mysql_db_query ("aggies", $query);
if ($result)
{
if (mysql_num_rows($result))
{
echo "\n";
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
$info = mysql_fetch_object ($result);
printf("- %s, %s, %s %s
\n", $info->lname, $info->fname, $info->class, $info->email, $info->email);
}
echo "
\n";
} else
echo "No Matches to your Query
\n";
mysql_free_result($result);
} else
printf("%s (%s)\n", mysql_error(), $query);
}
?>
Back to Aggie Band Members Page
I am reachable at rhay@tamos.net