'; $sql = 'SELECT * FROM news, people WHERE news.author_id = people.person_id ORDER BY date DESC LIMIT 1'; $result = $db->query($sql); $row = $result->fetch_assoc(); echo '

'; echo '

'.date('d F Y', strtotime($row['date'])).'

'; echo '

'.$row['title'].'

'; echo '

'.$row['text'].'

'; echo '

— '; echo $row['nickname'] ? $row['nickname'] : $row['first_name'].' '.$row['last_name']; echo '

'; echo '

more news >>

'; echo ''; $sql = 'SELECT picture FROM fliers WHERE event_id='.$lastevent['event_id'].' AND side="front"'; $result = $db->query($sql); $row = $result->fetch_assoc(); if($row['picture']) { echo '

'; echo '

'.date('d F Y', strtotime($lastevent['date'])).'

'; echo ' last flier

'; echo '

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