\n", mysql_num_rows($result)); printf("

\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); for ($i = 0; $i < mysql_num_rows($result); $i++) { /* Here it gets the data */ $info =mysql_fetch_object($result); printf("\n", $info->class); printf("\n", $info->lname, $info->fname); printf("\n", $info->email, $info->email); } printf("

Class of	Name	Email Address
%s	%s, %s	%s

\n"); printf("

\n"); } else printf("No Matches to your Query

\n"); mysql_free_result($result); } else printf("%s (%s)\n", mysql_error(), $query); } mysql_connect("localhost","rhay","AmazonDesert"); if ($activate != "") { $email_query = "select * from members where ". "email is not null order by class,lname"; querydb($email_query); } mysql_close(); ?>