Query("select ACME_Locations.City, ACME_Locations.State, ACME_Seminars.Time, ACME_Seminars.ID from ACME_Locations, ACME_Seminars where ACME_Seminars.Location = ACME_Locations.ID order by ACME_Seminars.Time"); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $city = $sql->data[0]; $state = $sql->data[1]; $date = date("M d",MkUnixTime($sql->data[2])); $id = $sql->data[3]; echo("\n"); $sql2->Query("select * from ACME_Attendee where Seminar = $id order by LastName, FirstName"); for ($j = 0; $j < $sql2->rows; $j++) { $sql2->Fetch($j); $id = $sql2->data[ID]; $fname = $sql2->data[FirstName]; $lname = $sql2->data[LastName]; $city = $sql2->data[City]; $state = $sql2->data[State]; $paid = $sql2->data[Paid]; $payment = $sql2->data[PaymentType]; echo("\n"); echo("\n"); echo("\n"); } if ($sql2->rows == 0) { echo("\n"); } } echo("\n"); echo("

	Name	City, State	Payment Type	Paid
$city, $state on $date
	$fname $lname	$city, $state	$payment	$paid
No Attendee's registered for this seminar
\n"); echo("\n"); echo("\n"); echo("

\n\n"); include("footer.php3"); ?>