$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 '