ISO50

RSS

Events / Shows

Posted by Scott

$current_date = date("Ymd");
//
$query = "SELECT * FROM cms_events_widget WHERE event_date >= $current_date ORDER BY event_date”;
$result = mysql_query($query);
if(mysql_num_rows($result) > 0) {
for($i=0; $i<$row = @mysql_fetch_array($result);$i++) {
$id = $row["id"];
$event_date = $row["event_date"];
$month = substr($event_date,4,2);
$day = substr($event_date,6,2);
$year = substr($event_date,2,2);
$event_date_cat = $month.'/'.$day.'/'.$year;
$body = $row["body"];
$body = urldecode(nl2br($body));
$title = $row["event_title"];
$title = urldecode($title);
$location = $row["location"];
$info_link = $row["info_link"];
$image = $row["photo"];

?>
” border=”0″>

}
}
?>

Comments are closed.