Create("churchil_demo");
?>
Conference Registrations
| Location |
Date |
|
Gross $ |
|---|
Query("select ACME_Locations.City, ACME_Locations.State, ACME_Seminars.Time, ACME_Seminars.ID, ACME_Seminars.MaxAttend, ACME_Seminars.Attendance, ACME_Seminars.Fee 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];
$max = $sql->data[4];
$curr = $sql->data[5];
$open = $max - $curr;
$fee = $sql->data[6];
echo("| $city, $state | \n");
echo(" $date | \n");
if ($curr > 0) {
echo(" ");
for ($j = 0; $j < $curr; $j++) {
echo("![\"*\"](\"images/block.gif\") ");
}
echo(" | \n");
} else {
echo(" | \n");
}
if (($max - $curr) <= 0) {
echo(" Full ($curr) | \n");
} else {
echo(" $curr | \n");
}
$money = $curr * $fee;
echo("\$$money |
\n");
}
?>
Click on the Seminar's City/State for a full listing of who has
registered for that particular seminar. This detailed report includes
names, addresses and payment status.