print $header; ?>
Class |
|
$sql = "select a.classid, a.description, a.timeinfo, b.date1, b.date2, b.date3, b.date4,b.date5,b.date6, b.date7, b.date8,b.date9, b.date10, b.date11, b.date12 from ".$table."webclasses a, ".$table."classes b
where a.classid = b.classid order by a.pos";
$result = mysql_query($sql) or die($sql);
while ($row = mysql_fetch_row($result))
{
$classid = $row[0];
$desc = $row[1];
$timeinfo = $row[2];
$date1 = format($row[3]);
$date2 = format($row[4]);
$date3 = format($row[5]);
$date4 = format($row[6]);
$date5 = format($row[7]);
$date6 = format($row[8]);
$date7 = format($row[9]);
$date8 = format($row[10]);
$date9 = format($row[11]);
$date10 = format($row[12]);
$date11 = format($row[13]);
$date12 = format($row[14]);
// get the class information
$sqli = "select title, maxdogs, cost from ".$table."classes where classid = $classid";
$resulti = mysql_query($sqli);
while ($rowi = mysql_fetch_row($resulti))
{
$title = $rowi[0];
$maxdogs = $rowi[1];
$cost = $rowi[2];
// if cost has a $ replace it
$cost = str_replace("$","",$cost);
}
// print the information
if ($bg == "#F7F9F7") $bg = "#E8EEE8";
else $bg = "#F7F9F7";
print "
$title - $$cost ";
print "$timeinfo ";
if ($date1) { print "Class Dates: $date1 $date2 $date3 $date4 $date5 $date6 $date7 $date8 $date9 $date10 $date11 $date12 "; }
print "
$desc";
$sqlenr = "select count(*) from ". $table . "roster where classid = $classid";
$enrolled = 0;
$resultenr = mysql_query($sqlenr) or die($sqlenr);
while ($myrowenr = mysql_fetch_row($resultenr))
{
$enrolled = $myrowenr[0];
}
$avail = $maxdogs - $enrolled;
print " | Spaces available: $avail
Sign Up";
}
// print the contact information here
?>
|
print "Contact Information
$person
$email
$phone
$address
$city $state $zip
";
?>
Powered by EdogTrainer.com
print $footer; ?>