Mike Ryan wrote:
Sorry I am a bit of a newbie with php and hope this has not been aswered a
million times, but here it goes
I have a date base with a couple of date fields when I pull up and display
the fields it show 2007-05-21. the question I have is how to convert the
field to 05-21-2007?
Currently the command I have is
print $row['open'];
Well the easiest thing is to let MySQL do the work
use following SELECT
SELECT DATE_FORMAT(your_date_field,'%m-%d-%Y') as date_field FROM yourtable
That should do the work...
--
Johan Holst Nielsen
Freelance PHP Developer - http://phpgeek.dk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php