Hi Guys,

I have a little problem with pulling a DATE from a database. Below is my code for the page I am trying to create.

I have in the database a date - 2011-07-27 and I am trying to set the dates into an array so that I can organise dates into YEAR and MONTH.

Now, I don't know if the database is the problem. The field is set to DATE.

// Add each entry to the $data array, sorted by Year and Month
while($row = $result->fetch_assoc())
{
$year = date('Y', $row['articleDate']);
$month = date('m', $row['articleDate']);

$data[$year][$month][] = $row;
}
$result->free();

The above code returns 1970 for year and 01 for month.

Help Please

Thank you

Live example: http://www.klsactivelifestyle.co.uk/archive.php

date expects the second parameter to be a timestamp (integer), not a mysql formatted date. Use strtotime to convert the date to a timestamp first and then format it with date.

PHP Code:

while($row = $result->fetch_assoc())
{
     $ts = strtotime($row['articleDate']);
     $year = date('Y', $ts);
     $month = date('m', $ts);
/* 
.
.
.
*/ 


That's worked perfectly! Thanks.

Updated dates: www.klsactivelifestyle.co.uk/archive.php