Events »
-
$sQuery = "SELECT * FROM tbl_event ORDER BY event_id DESC LIMIT 5";
$objRs = mysql_query($sQuery);
if (mysql_num_rows($objRs)!=0)
{
while ($row = mysql_fetch_array($objRs))
{
$sEvent_id = trim($row["event_id"]);
$sEvent_title = trim($row["event_title"]);
$sEvent_date = trim($row["event_date"]);
$dateDisp = explode('-', $sEvent_date);
$year = $dateDisp[0];
$month = $dateDisp[1];
$monthName = date("M", mktime(0, 0, 0, $month, 10));
$day = $dateDisp[2];
$sEvent_time_a = trim($row["event_time_a"]);
$sEvent_time_b = trim($row["event_time_b"]);
$sEvent_time_c = trim($row["event_time_c"]);
$sEvent_time_d = trim($row["event_time_d"]);
$sEvent_location = trim($row["event_location"]);
$sEvent_pic = trim($row["event_pic"]);
?>
-
echo $monthName; ?> echo $year; ?>echo $day; ?>
echo $sEvent_title; ?>
Time: echo $sEvent_time_a; ?> echo $sEvent_time_b; ?> - echo $sEvent_time_c; ?> echo $sEvent_time_d; ?>
}
}
?>