rendered paste body$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); $query = "SELECT *, date_format(timestamp,'%d/%m/%Y') as date FROM `articles` WHERE articles.statusid =4 AND articles.articleID LIMIT 0 , 5"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());if (mysql_num_rows($result) > 0) { while($row = mysql_fetch_assoc($result)) { $date = $row['date']; list($month, $day, $year) = split('[/.-]', $date); echo "Date from database ="; echo $row["date"]; echo '<br>'; echo "Date after format ="; echo $date; echo '<br>'; if ($lastYear == $year) { echo '<div class="item">'; echo '<div class="header-container">'; echo '<div class="left-curve"> </div>'; echo '<div class="articleTitle">'; echo "<h1>".$date."</h1>"; echo '</div>'; echo '<div class="right-curve"> </div>'; echo '</div>'; echo '</div>'; echo '<div class="clear">'; echo '</div>'; } $lastYear = $date; } }else echo 'No articles have been selected for viewing'; // free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>