//$menu = a;
$section = $_GET["section"];
$topic = $_GET["topic"];
$sub = $_GET["sub"] ? $_GET["sub"] : "0";
$max = 5;
//$top_section = substr($sub_section, 0, 1);
?>
|
$query = "SELECT *
FROM course AS c, timetable AS t
WHERE c.id = t.course_id
AND c.activity_id = '1'
AND DATEDIFF( t.end,
CURRENT_TIMESTAMP ) >0 AND c.curriculum_id >= 8
ORDER BY t.end
LIMIT 0 , 5";// >=7
$result = mysql_query($query);?>
while($row = mysql_fetch_array($result)){
?>
|
echo substr($row['end'],8,2); ?> |
$month = substr($row['end'],5,2);
switch ($month) {
case "01":
echo "JAN";
break;
case "02":
echo "FEB";
break;
case "03":
echo "MAR";
break;
case "04":
echo "APR";
break;
case "05":
echo "MAY";
break;
case "06":
echo "JUN";
break;
case "07":
echo "JUL";
break;
case "08":
echo "AUG";
break;
case "09":
echo "SEP";
break;
case "10":
echo "OCT";
break;
case "11":
echo "NOV";
break;
case "12":
echo "DEC";
break;
}
?> |
|
|
公眾講座
echo $row['topic_hk']; ?> |
| | echo $row['introduction_hk']; ?> |
|
|
} ?>
|
|
include("footer.php"); ?> |