Date('r') function not working

[Minklet]

Hi, I'm making an RSS feed

 

http://dev.subverb.net/mixes_rss.php

 

and as you see the date('r', $row['date']) function is not converting it. I've echo'd $row['date'] into the description to show what format the date is in (just mysql datetime. Am I missing something?

 

Thanks

[BlueSkyIS]

date() takes a timestamp. you'll need to convert to timestamp via SQL or PHP before using date().

 

http://php.net/manual/en/function.date.php

[PFMaBiSmAd]

Just use the mysql DATE_FORMAT() function in your query when you retrieve the value. No slow parsed, tokenized, interpreted php code is needed. You are already executing a query to retrieve the data. Adding a mysql DATE_FORMAT() function in the query adds a minuscule amount of time to the query, whereas doing this in php code takes a minimum of 8 times longer then it takes to execute the entire query.

[Minklet]

I did this, which I found.

 

gmdate('D, d M Y H:i:s \G\M\T', strtotime($row[7]))

 

 

When I go through an optimise my queries next week I'll use DATE_FORMAT

 

Thanks