Events at Sumac

"; } $today = date("Y-m-d"); $count=1; // SELECT FOR MAIN OUTPUT $xyear=date("Y",strtotime($today)); $xmonth=date("m",strtotime($today)); $xday=date("d",strtotime($today)); $xtoday=date("Y-m-d H:i:s",mktime(00,00,00,$xmonth,$xday,$xyear)); { $query3 = "SELECT * FROM ARC WHERE (DateTime >= '$xtoday' OR EndDate>'$today') AND (MapLink = 'sumac' OR GroupName='Sumac Centre') ORDER BY DateTime"; } $result = mysql_query($query3) or die ("could not execute query3"); $checkmonth = "X"; // used to check for beginning of new month while ($row = mysql_fetch_array($result)) { extract ($row); $eventref = "$IndexNo"; $displayday = date("l",strtotime($DateTime)); $displaydate = date("jS M y",strtotime($DateTime)); $starttime = date("G:i",strtotime($DateTime)); $displayendtime = date("G:i",strtotime($EndTime)); $displayendday = date("l",strtotime($EndDate)); $displayenddate = date("jS M",strtotime($EndDate)); $count=$count+1; echo "

$displaydate : "; echo "$Header . "; echo "$RepeatDetail

\n"; } echo "$count events listed

See Full Sumac Diary for like-minded events elsewhere in Nottingham, and beyond."; ?>