Problem with display date and time format?

dazraf

Hi guys, I'm new to PHP so don't expect me know everything!

I've table in db called 'comments', within this table there is field dedicated just for the date and time of when comment was published/created!

Here is what I have done so far, but is giving me different output! I want it to display the date and time format as 'l j/m/Y H:i' instead of 'Y-m-j H:i:s'.

$q = mysql_query('select * from comments');
while($r = mysql_fetch_array($q)){
$id = $r['id'];
$title = $['title'];
$text = $r['text'];
[B]$created  = date('l j/m/Y H:i', $r['created']);[/B]
}

The 'created' field type is set to 'datetime'.

Thanks in advance!

dazraf

And here is the output!
Have a look at the attachment!
Thanks!

dazraf

Have a look at the attachment!

bradgrafelman

Read the manual page for [man]date/man. The optional second parameter is supposed to be a Unix timestamp (e.g. an integer).

Instead, you might want to use MySQL's DATE_FORMAT() function. Otherwise, you'll have to convert the DATETIME column into a Unix timestamp (e.g. by using MySQL's UNIX_TIMESTAMP() function) and then transforming that Unix timestamp using PHP's date() command.

dazraf

Thanks! But still having problem! I've read the DATE TIME manual on php.net, but didn't help as it requires a better understanding on date and time...

So can somebody help me with this!
Can you write me a simple one that is in UK date format!
Thanks!