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 "";
print " ![](\"http://admin.thelinkthamesmead.co.uk/uploads/mid_")
"; print "
"; print ""; print html_entity_decode($event['subtitle']); print "
"; print "
" . html_entity_decode($event['title']) . "
"; print "" . date('jS F Y', strtotime($event['date'])) . "
"; print ""; print html_entity_decode($event['subtitle']); print "
"; print ""; } ?>
";
print "
";
}
} else {
// WE HAVE A SPECIFIC ID, SO DRAW ALL THE DETAILS IN
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($partner_name) . " " . date('g.ia', strtotime($tr['date_time'])) . "
";
print html_entity_decode($event['subtitle']);
print "
";
}
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 " ";
$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 "
";
$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 "
"; print "
"; print "
"; print ""; } print "
";
print "
"; print html_entity_decode($row['description']); 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 "