Balloon Safety
Creating Exotic Animals
Fear of Clowns, more common than you thought
Taming the Terrible Two-year old
|
City |
Date |
Seats Left |
require("util.php3");
$sql = new MySQL_class;
$sql->Create("churchil_demo");
$sql->Query("select ACME_Locations.City, ACME_Locations.State, ACME_Seminars.Time, ACME_Seminars.ID, ACME_Seminars.MaxAttend, ACME_Seminars.Attendance 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;
if ($open <= 0) {
echo("$city, $state | $date | \n");
echo(" Full | \n");
} else {
echo("$city, $state | $date | $open | \n");
}
}
?>
|