Coming soon

= NOW() AND date(`link_programme_repeat`.`date`) < NOW() + INTERVAL 2 MONTH AND ". " `link_media2programme`.`media_ID` = `link_media`.`media_ID` ". " GROUP BY `title` ORDER BY `featured` DESC, RAND() LIMIT 2"); $all_events = mysql_num_rows($s); for($e = 0; $e < $all_events; $e++) { $event = mysql_fetch_array($s); print "
"; print "
"; } ?>

Filter Result

= DATE_SUB(NOW(), INTERVAL 1 DAY) "; } else { $from_date = ""; } $sql = mysql_query("SELECT DISTINCT(`date`) FROM `link_programme_repeat` NATURAL JOIN `link_programmes` WHERE month(`date`) = $target_month AND year(`date`) = $dispYear $day_list $from_date GROUP BY `date`"); $all_rows = mysql_num_rows($sql); for($i = 0; $i < $all_rows; $i++) { $row = mysql_fetch_array($sql); $this_day = $row['date']; print "
"; print "
" . date('l jS F Y', strtotime($this_day)) . "
"; $query = "SELECT * FROM (`link_programme_repeat` NATURAL JOIN `link_programmes`),". " (`link_programme2partner` NATURAL JOIN `link_partners`)". " WHERE `link_programme_repeat`.`programme_ID` = `link_programme2partner`.`programme_ID` AND ". " `link_programme_repeat`.`date` ='$this_day' ORDER BY `link_programme_repeat`.`date`, DATE_FORMAT( `link_programmes`.`date_time` , '%H:%i:%s' )"; //echo $query; $s = mysql_query($query); $all_events = mysql_num_rows($s); for($e = 0; $e < $all_events; $e++) { $event = mysql_fetch_array($s); $this_p_ID = $event['programme_ID']; $t = mysql_query("SELECT * FROM `link_programmes` NATURAL JOIN (`link_programme2category` NATURAL JOIN `link_categories`) WHERE `link_programmes`.`programme_ID` = $this_p_ID"); $all_cats = mysql_num_rows($t); $filter_string = ""; for($cats = 0; $cats < $all_cats; $cats++) { $tr = mysql_fetch_array($t); $filter_string .= strtolower(" filter_for_" . $tr['category_title']); } print "
"; print ""; print " Click for more ▶"; print "

" . html_entity_decode($event['title']) . "

"; print "
"; $partner_name = $event['partner_name'] == "Other" ? "" : $event['partner_name']; print "

" . html_entity_decode($partner_name) . " " . date('g.ia', strtotime($tr['date_time'])) . "
"; if( $event['partner_directions'] ) { print "(" . nl2br(strip_tags(html_entity_decode($event['partner_directions']))) . ")"; } print "

"; print html_entity_decode($event['subtitle']); print "
"; } print "
"; } } else { // WE HAVE A SPECIFIC ID, SO DRAW ALL THE DETAILS IN print "
"; print "
"; $s = mysql_query("SELECT * FROM `link_media2programme` NATURAL JOIN `link_media` WHERE `programme_ID` = $programme_ID ORDER BY `media_order`"); $all_events = mysql_num_rows($s); for($e = 0; $e < $all_events; $e++) { $event = mysql_fetch_array($s); print "
"; print "
"; print "

"; print "
"; } print "
"; $q = "SELECT `link_programmes`.`title`, `link_programmes`.`date_time` AS `time`, `link_programmes`.`description`, `link_partners`.`partner_name`, `link_partners`.`partner_address`, `link_partners`.`partner_directions`, `link_programmes`.`subtitle`, `link_programme_repeat`.`date` FROM `link_programmes`,(`link_programme2partner` NATURAL JOIN `link_partners`),(`link_programme2category` NATURAL JOIN `link_categories`), `link_programme_repeat` WHERE `link_programmes`.`programme_ID` = `link_programme2partner`.`programme_ID` AND `link_programmes`.`programme_ID` = `link_programme2category`.`programme_ID` AND `link_programmes`.`programme_ID` = '$programme_ID' AND `link_programme_repeat`.`programme_ID` = '$programme_ID' AND date(`link_programme_repeat`.`date`) >= CURDATE()"; //echo $q; $sql = mysql_query($q); $row = mysql_fetch_array($sql); print "
"; print "

" . html_entity_decode($row['title']) . "

"; print "

" . html_entity_decode($row['partner_name']) . ". Next on: " . date('jS F', strtotime($row['date'])) . " at " . date('g.ia', strtotime($row['time'])) . "

"; //print html_entity_decode($row['subtitle']); print "

" . html_entity_decode($row['subtitle']) . "

"; //print "

" . html_entity_decode($row['partner_name']) . "

"; print "
"; print html_entity_decode($row['description']); print "
"; print "

" . nl2br(html_entity_decode($row['partner_address'])) . "

"; print "

" . html_entity_decode($row['partner_directions']) . "

"; print "
"; } ?>