rendered paste bodyif (mysql_num_rows($result) > 0) { while($row = mysql_fetch_assoc($result)) { $date = $row['date']; list($day, $month, $year) = split('[/.-]', $date); //echo "Date from database ="; //echo $row["date"]; //echo '<br>'; //echo "Date after format ="; //echo $year ; //echo '<br>'; if ($lastYear !== $year) { echo "</table>"; echo '<div class="item">'; echo '<div class="header-container">'; echo '<div class="left-curve"> </div>'; echo '<div class="articleTitle">'; echo "<h1>".$year."</h1>"; echo '</div>'; echo '<div class="right-curve"> </div>'; echo '</div>'; echo '</div>'; echo '<div class="clear">'; echo '</div>'; } if ($lastMonth !== $month) { echo "</table>"; echo '<div class="item">'; echo '<div class="header-container">'; echo '<div class="left-curve"> </div>'; echo '<div class="articleTitle">'; echo "<h1>".$months[(int) $month]."</h1>"; echo '</div>'; echo '<div class="right-curve"> </div>'; echo '</div>'; echo '</div>'; echo '<div class="clear">'; echo '</div>'; echo "<table width=\"600px\" >"; echo "<tr align ='left'><th>Title</th><th>Author</th><th>Category</th><th>Date Submitted</th><th>View</th></tr>"; } $lastMonth = $month; $lastYear = $year; echo $row["articleTitle"]; echo '<br>'; echo $row["date"]; } }else echo 'No articles have been selected for viewing'; // free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>