"; $start++; } $weekday++; while($day<=$last_days) { if($day<10){ $date = "0$day"; }else{ $date = "$day"; } $sql_date = "SELECT * FROM training_room_timetable where month = '".$mmm."' and date = '".$day."' and year = '".$year."' and course_id != 'Activity'"; $result_date = mysql_db_query($dbname,$sql_date); $num_date = mysql_num_rows($result_date); //$array = mysql_fetch_array($result_date); if($num_date == 0){ $num = "-"; }else{ $num = "$num_date vistors"; } $num_week = $num_week + $num_date; $d_tx = "$date"; $week_tx = $week_tx." ".$d_tx; echo ""; echo ""; $weekday=0; $num_week=0; $week_tx = ""; } // $num_week = $num_week + $num_date; $day++; $weekday++; } while($weekday<=7) { // echo ""; $weekday++; }//echo ""; ?>
Sun Mon Tue Wed Thu Fri Sat
$day
"; while($array = mysql_fetch_array($result_date)) { $course_id = $array['course_id']; $sql_course = "SELECT * FROM training_courses_new where id = '$course_id'"; $result_course = mysql_db_query($dbname,$sql_course); $array_course = mysql_fetch_array($result_course); $title = $array_course['title']; $group = $array_course['num']; if($array_course['num']== 0) { $group = "-"; } if($array_course['title'] == "Academic Writing II") { $title = "ACDM Writing II"; } if($array_course['title'] == "TOEFL iBT (Internet based test) Preparation") { $title = "TOEFL iBT"; } if($array_course['title'] == "General English Test Preparation") { $title = "General English"; } if($array_course['title'] == "Basic English Grammar") { $title = "Grammar"; } if($array_course['title'] == "English for Business") { $title = "Eng for Business"; } if($array_course['title'] == "English for Communication and Office Work") { $title = "Eng for Commu..."; } if($array_course['title'] == "English for Communication") { $title = "Eng for Commu..."; } if($array_course['title'] == "CU-TEP Preparation") { $title = "CU-TEP"; } if($array_course['title'] == "IELTS Preparation") { $title = "IELTS"; } if($array_course['title'] == "English for Presentation") { $title = "Eng Presentation"; } if($array_course['title'] == "English for Communication (Meeting)") { $title = "Eng for Meeting"; } if($array_course['title'] == "English for Communication (Telephoning)") { $title = "Eng for Telephone"; } if($array_course['title'] == "English for Presentation" and $array_course['num'] == "P1/2556") { $title = "Eng Present AHS"; } if($array_course['title'] == "English for Hospitality Tourism and Airlines Business") { $title = "Eng Airlines"; } if($array_course['title'] == "English Test Preparation Course") { $title = "Eng Test Prep"; } if($array_course['title'] == "Listening Skill Preparation") { $title = "Listening Skill"; } if($array_course['title'] == "English Test Preparation Course(Vocabulary Building)") { $title = "Vocab Building"; } if($array_course['title'] == "Cambridge English Placement Test Preparation") { $title = "CEPT"; } if($array_course['title'] == "Cambridge English Placement Test Preparation (Upper Level)") { $title = "CEPT (Upper)"; } if($array_course['title'] == "Cambridge English Placement Test Preparation (Upper Intermediate -> Advanced Level)") { $title = "CEPT (Upper)"; } if($array_course['title'] == "Cambridge English Placement Test Preparation (Lower Level)") { $title = "CEPT (Lower)"; } if($array_course['title'] == "Cambridge English Placement Test Preparation (Beginner -> Pre-intermediate Level)") { $title = "CEPT (Lower)"; } if($array_course['title'] == "English Usage for Office Work (Emailing)") { $title = "Eng for Emailing"; } if($array_course['title'] == "English for Communication (Listening and Speaking)") { $title = "Eng for Commu..."; } if($array_course['title'] == "Basic Thai 1 for Foreign Students") { $title = "Thai for Foreign"; } if($array_course['title'] == "French for Communication") { $title = "French for Com..."; } if($array_course['title'] == "Elementaire") { $title = "Elementaire"; } if($array_course['title'] == "Elementaire II") { $title = "Elementaire II"; } if($array_course['title'] == "Français sur objectifs spécifiques-FOS") { $title = "FOS"; } if($array_course['title'] == "Débutant 1") { $title = "Débutant 1"; } if($array_course['title'] == "Débutant 2") { $title = "Débutant 2"; } if($array_course['title'] == "Intensive") { $title = "Intensive"; } if($array_course['title'] == "TOEFL Prepareation") { $title = "TOEFL"; } ?> •
"; if($weekday==7 and $day!=$last_days) { // echo "
$num_week
vistors
 $num_week
vistors

<-Previous month

Next month->