query($sql); $event = $result->fetch_assoc(); // changing format of date and time $event['date'] = date('d F Y',strtotime($event['date'])); $event['start'] = timeTo12($event['start'], 1); $event['end'] = timeTo12($event['end'], 1); // get lineup for given event $sql = 'SELECT lineups.room_id, lineups.dj_id, djs.name FROM lineups, djs WHERE event_id='.$_GET['event_id'].' AND lineups.dj_id = djs.dj_id ORDER BY lineups.priority'; $lineup = $db->query($sql); // get flyer for given event $sql = 'SELECT picture FROM fliers WHERE side="front" AND event_id='.$_GET['event_id']; $result = $db->query($sql); $flier = $result->fetch_assoc(); $pic = $flier['picture'] ? substr($flier['picture'], 0, -5).'s.jpg' : 'images/noflier.gif'; $fl_size = getimagesize($pic); // get rooms for given club $sql = 'SELECT room_id, name FROM rooms WHERE club_id='.$event['club_id'].' ORDER BY priority'; $rooms = $db->query($sql); // display data echo '
'."\n"; echo '
'; echo 'flier'; echo '
'; echo '
'; echo '

'.$event['date'].'

'."\n"; echo '

'.$event['club'].' ('.$event['address'].')

'."\n"; echo '

'.$event['start']; echo $event['end'] ? ' - '.$event['end'] : ''; echo '

'."\n"; echo '

'.$event['cover'].', '.$event['age'].'

'."\n"; echo ''."\n"; echo '
'; echo ''; echo '
'; if($event['description']) { echo '

Description:

'."\n"; echo ''.$event['description'].'

'."\n"; } if($event['summary']) { echo '

Summary:

'."\n"; echo '

'.$event['summary'].'

'."\n"; } echo '
'; echo '
'."\n"; // display bottom controls displayControls($current, 'events.php', 'bottomctrl'); } else { echo '

>> Events <<

'; listEvents('events.php'); } //include bottom include_once('bottom.php'); ?>