<?php
//include top of the page
include_once('top.php');

// main
$sql = 'SELECT * FROM news, people WHERE news.author_id = people.person_id ORDER BY date DESC';
$result = $db->query($sql);
echo '<div id="news">';
while($row = $result->fetch_assoc()) {
	echo '<div class="one-news">';
	echo '<p class="date">'.date('d F Y', strtotime($row['date'])).'</p>';
	echo '<h2>'.$row['title'].'</h2>';
	echo '<p class="text">'.$row['text'].'</p>';
	echo '<p class="author">&mdash; <span>';
	echo $row['nickname'] ? $row['nickname'] : $row['first_name'].' '.$row['last_name'];	
	echo '</span></div>';
}
echo '</div>';

//include bottom
include_once('bottom.php');
?>