Upcoming Shows Page

'$now' AND `venue_id`=3 GROUP BY `venue_id` ORDER BY `date` ASC"; $upcoming_qry = $con->query($upcoming_sql); while($upcoming_rst = $upcoming_qry->fetch_assoc()){ $upcoming_venue_group = $upcoming_rst['venue_id']; $venue_sql = "SELECT * FROM `venues_tbl` WHERE `ID`=$upcoming_venue_group"; $venue_qry = $con->query($venue_sql); $venue_rst = $venue_qry->fetch_assoc(); $venue_name = $venue_rst['name']; $venue_street = $venue_rst['street']; $venue_town = $venue_rst['town']; $venue_county = $venue_rst['county']; $venue_postcode = $venue_rst['postcode']; echo '

'.$venue_town.'

'; echo '

'.$venue_name.', '.$venue_county.', '.$venue_postcode.'

'; $up_gig_sql = "SELECT * FROM `gigs_tbl` WHERE `date`>'$now' AND `venue_id`=$upcoming_venue_group ORDER BY `date` ASC"; $up_gig_qry = $con->query($up_gig_sql); while($up_gig_rst = $up_gig_qry->fetch_assoc()){ echo '

'.gmdate('l jS F',$up_gig_rst['date']).' - '.gmdate('g:ia',$up_gig_rst['date']).'
£'.$up_gig_rst['admission'].'

';//.' advanced or £'.$otdPrice.' on the door

'; $gig_id = $up_gig_rst['ID']; $date = $up_gig_rst['date']; if($up_gig_rst['admission']>5){ $act_sql = "SELECT * FROM `bills_tbl` WHERE `gig_id`=$gig_id AND `position`=1"; $act_qry = $con->query($act_sql); $act_rst = $act_qry->fetch_assoc(); $act_ID = $act_rst['act_id']; $act_qry = $con->query("SELECT * FROM `acts_tbl` WHERE `ID`=$act_ID"); $act_rst = $act_qry->fetch_assoc(); $act_name = $act_rst['first_name'].' '.$act_rst['surname']; $act_ref = str_replace(' ','-',strtolower($act_name)); } else { $act_name = 'Live Stand Up'; $act_ref = 'ffc-social-logo'; } echo '

'; echo '

'.$act_name.'

'; $guest_sql = "SELECT * FROM `bills_tbl` WHERE `gig_id`=$gig_id AND `position`=2"; $guest_qry = $con->query($guest_sql); $guest_rst = $guest_qry->fetch_assoc(); $guest_ID = $guest_rst['act_id']; $guest_qry = $con->query("SELECT * FROM `acts_tbl` WHERE `ID`=$guest_ID"); if($guest_qry->num_rows>0){ $guest_rst = $guest_qry->fetch_assoc(); $guest_name = $guest_rst['first_name'].' '.$guest_rst['surname']; echo '

Plus Special Guest '.$guest_name.'

'; } $support_sql = "SELECT * FROM `bills_tbl` WHERE `gig_id`=$gig_id AND `position`=3"; $support_qry = $con->query($support_sql); $support = Array(); while($support_rst = $support_qry->fetch_assoc()){ $support_id = $support_rst['act_id']; $support_act_sql = "SELECT * FROM `acts_tbl` WHERE `ID`=$support_id"; $support_act_qry = $con->query($support_act_sql); $support_act_rst = $support_act_qry->fetch_assoc(); $support_fname = $support_act_rst['first_name']; $support_sname = $support_act_rst['surname']; $support_identifier = $support_act_rst['unique_identifier']; array_push($support, Array("$support_fname $support_sname","$support_identifier")); } sort($support); $supC = count($support); if($supC>0){ echo '

Support: '; $si = 0; while($si<$supC){ echo $support[$si][0].', '; $si++; } $mc_sql = "SELECT * FROM `bills_tbl` WHERE `gig_id`=$gig_id AND `position`=0"; $mc_qry = $con->query($mc_sql); $mc_rst = $mc_qry->fetch_assoc(); $mc_ID = $mc_rst['act_id']; $mc_qry = $con->query("SELECT * FROM `acts_tbl` WHERE `ID`=$mc_ID"); $mc_rst = $mc_qry->fetch_assoc(); $mc_name = $mc_rst['first_name'].' '.$mc_rst['surname']; echo 'and MC '.$mc_name.'

'; } elseif($venue_name=='The Winning Post'){ echo '

New and Established Acts

'; } else { echo '

plus support

'; } if($date<($now+60*60*24*90)){ if($venue_name=='The Winning Post'){ if($up_gig_rst['admission']<6){ $act_ref = 'the-winning-post.php?date='.gmdate('Ymd',$up_gig_rst['date']); } } echo "

Get your tickets now"; } else { echo "

Tickets are not on sale for this event. Keep an eye on the site, or join the mailing list to be kept up to date.

"; } echo "

"; } ?>

Mailing List

Join our mailing list, and get information about our upcoming shows straight to your inbox.

No more than two emails a month.