| |
Printer Friendly schedule: Current Month
Next Month
= CURDATE()) ORDER BY ClassScheduleMaster.Location, ClassScheduleMaster.ClassTitle, ClassScheduleMaster.DOC";}
else
{$query="SELECT date_format(ClassScheduleMaster.DOC,'%m/%d/%y') as DOC, ClassScheduleMaster.ClassID, ClassScheduleMaster.ClassTitle, ClassScheduleMaster.Location, Category, Topics, ClassTitles.Link, Length as LengthofClass, Cost From ClassTitles INNER JOIN ClassScheduleMaster ON ClassTitles.ClassTitle = ClassScheduleMaster.ClassTitle WHERE (ClassScheduleMaster.Public = 'Yes') and (Category='$select') and (Month(ClassScheduleMaster.DOC) = $Month and Public = 'Yes' and ClassScheduleMaster.DOC >= CURDATE()) ORDER BY ClassScheduleMaster.Location, ClassScheduleMaster.ClassTitle, ClassScheduleMaster.DOC";}
//{$query="select ClassScheduleMaster.date_format(DOC,'%m/%d/%y') as DOC, ClassScheduleMaster.ClassID, ClassScheduleMasterClassTitle, ClassTitles.Category, ClassTitles.Topics, ClassTitles.Link, ClassTitles.LengthofClass , ClassTitles.Cost INNER JOIN ClassScheduleMaster ON ClassTitles.ClassTitle = ClassScheduleMaster.ClassTitle WHERE (Cat='$select' AND Month = $Month and DOC >= CURDATE()) ORDER BY 'Class', 'DoC'"};
$result=mysql_query($query);
$num=@mysql_numRows($result);
//mysql_close();
IF ($select == "All"){
$i=0;
while ($i < $num) {
$Location=mysql_result($result,$i,"Location");
$ClassID=mysql_result($result,$i,"ClassID");
$ClassTitle=mysql_result($result,$i,"ClassTitle");
$Category=mysql_result($result,$i,"Category");
$DOC=mysql_result($result,$i,"DOC");
$Topics=mysql_result($result,$i,"Topics");
$Link=mysql_result($result,$i,"Link");
$Length=mysql_result($result,$i,"LengthofClass");
$Cost=mysql_result($result,$i,"Cost");
//$DOC= ".date("d-m-Y : G-i",strtotime(mysql_result($result[DoC]))).";
$i++;
}
?>
| Location |
Class Title |
Category |
Topics (click link for more detail) |
Start Date |
# of days |
Cost |
Enroll in class |
|
|
|
|
|
|
|
$ |
Enroll
|
";
}
else
{$i=0;
while ($i < $num) {
$ClassID=mysql_result($result,$i,"ClassID");
$ClassTitle=mysql_result($result,$i,"ClassTitle");
$Category=mysql_result($result,$i,"Category");
$DOC=mysql_result($result,$i,"DOC");
$Topics=mysql_result($result,$i,"Topics");
$Link=mysql_result($result,$i,"Link");
$Length=mysql_result($result,$i,"LengthofClass");
$Cost=mysql_result($result,$i,"Cost");
//$DOC= ".date("d-m-Y : G-i",strtotime(mysql_result($result[DoC]))).";
$i++;
}
?>
| Class Title |
Topics (click link for more info) |
Start Date |
# of days |
Cost |
Enroll in class |
|
|
|
|
|
$ |
Enroll
|
";
}
?>
Go to your Enrollments>>
Classes are small and hands-on and all include reference manual.
For more information, or to register, please call 459-6600.
All classes are taught by Certified Microsoft Office Specialists.
|
Your address here / Your Phone Number here
Copyright [Year] [Your Company Name LTD]All rights reserved |
|
| |
|
