PHP to format date from Select *

[Anon]

I just can't get this... HELP

I do a select *

then try

$nicedate = date ("F j, Y, g:i a", mktime ($MYDATEFIELD));

This returns TODAY as the date.

All dates in my tables look something like... 1997-11-03 12:10:55

[Anon]

mktime() is expecting a UNIX timestamp - you are providing a MySQL format .. either way its faster to let MySQL do the formatting for you, check out DATE_FORMAT() in the MySQL manual

i.e... SELECT DATE_FORMAT(date_field,'%a %M %D %Y')