$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 '
'; echo "Date after format ="; echo $date; echo '
'; if ($lastYear == $year) { echo '
'; echo '
'; echo '
'; echo '
'; echo "

".$date."

"; echo '
'; echo '
'; echo '
'; echo '
'; echo '
'; echo '
'; } $lastYear = $date; } } else echo 'No articles have been selected for viewing'; // free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>