",$lb;
if ($row_qryClasses['IMG_FILE'] != '') {
echo "";
}
echo "Class ID: ",$row_qryClasses['NC_CLASS_ID']," - ",$row_qryClasses['TC_TITLE']."".$dlb;
echo "Teacher: ";
if ($row_qryClasses['TC_TEACHER_PAGE'] != '') {
echo '';
}
echo $row_qryClasses['TC_TEACHER_NAME'];
if ($row_qryClasses['TC_TEACHER_PAGE'] != '') {
echo '';
}
echo $lb;
echo "Class Level: " . $row_qryClasses['TC_SKILL_LEVEL'].$lb;
echo "Class Type: ".ClassType(intval(time_diff($row_qryClasses['TC_END_TIME'],$row_qryClasses['TC_START_TIME']))/60).$lb;
$da = explode("-",$row_qryClasses['DT_CLASE_DATE']);
echo "Class Date: ".date('l F jS',mktime(0,0,0,$da[1],$da[2],$da[0])),$lb;
echo "Class Time: ".$row_qryClasses['TC_START_TIME']." to ".$row_qryClasses['TC_END_TIME'].$lb;
if ($row_qryClasses['TC_LOCATION'] != '') {
echo "Class Location: " . $row_qryClasses['TC_LOCATION'],$dlb;
}
else
{
echo $lb;
}
//echo date_diff($row_qrySubject['DT_CLASE_DATE'],$row_qrySubject['DT_CLASE_DATE'])\60."".$dlb;
echo $row_qryClasses['TC_DESCRIPTION'],$dlb;
echo "Students Will Learn: " . $row_qryClasses['TC_SKILLS_LEARNED'],$dlb;
if ($row_qryClasses['TC_HOMEWORK'] != '') {
echo "Homework: " . $row_qryClasses['TC_HOMEWORK'],$dlb;
}
if ($row_qryClasses['TC_PREREQ'] != '') {
echo "Class Prerequisites(Students should know): " . $row_qryClasses['TC_PREREQ'],$dlb;
}
if ($row_qryClasses['NC_MATERIAL_FEE'] != '' && $row_qryClasses['NC_MATERIAL_FEE'] != 0) {
echo "Materials Fee: ",dollar_format($row_qryClasses['NC_MATERIAL_FEE']);
echo " ";
echo " *Material fees are separate from class fees and ";
echo "paid to the instructor the day of the class.",$dlb;
}
if ($row_qryClasses['NC_MATERIAL_FEE_INCLUDES'] != '') {
echo "Materials Fee Includes: ",$row_qryClasses['NC_MATERIAL_FEE_INCLUDES'],$lb;
}
echo $lb;
if ($row_qryClasses['TC_MATERIALS'] != '') {
echo "Students Should Bring: " . $row_qryClasses['TC_MATERIALS'].$dlb;
}
if ($row_qryClasses['TC_PROVIDED_MATERIALS'] != '') {
echo "Teacher Will Supply: " . $row_qryClasses['TC_PROVIDED_MATERIALS'].$lb;
}
echo $lb;
echo "Minimum Age: ",$row_qryClasses['TC_MINIMUM_AGE'],$lb;
if ($row_qryClasses['NC_MAX_STUDENTS'] <> 0) {
echo "Maximum Class Size: ",$row_qryClasses['NC_MAX_STUDENTS'],$lb; }
echo "Class Fee: ",dollar_format($row_qryClasses['NC_FEE']),$lb;
$query_sc_text = sprintf("SELECT NC_STUDENT_ID_FK FROM STUDENT_CHOICES WHERE NC_CLASS_ID_FK = %s",
GetSQLValueString($row_qryClasses['NC_CLASS_ID'], "int"));
$qrySc = mysql_query($query_sc_text, $fiberfolk) or die(mysql_error());
$totalRows_qrySc = mysql_num_rows($qrySc);
if (!$VO){
//echo $totalRows_qrySc.", ".$row_qryClasses['NC_MAX_STUDENTS'];
if ($totalRows_qrySc < $row_qryClasses['NC_MAX_STUDENTS']) {
if (($row_qryClasses['NC_MAX_STUDENTS']-$totalRows_qrySc)>3) {
echo $lb," Add Class to Cart";
} else
{
echo $lb," Only ",$row_qryClasses['NC_MAX_STUDENTS']-$totalRows_qrySc, " seats left! Add Class to Cart";
}
} elseif ($row_qryClasses['NC_MAX_STUDENTS'] <> 0) {
echo $lb,"CLASS IS FULL",$lb;
} if ($row_qryClasses['NC_MAX_STUDENTS'] == 0) {
echo $lb,"CLASS IS CANCELLED";
}
}
echo "
|
";
}
?>