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