Re: [PHP] Easy Date & MySQL Question...

John Holmes wrote: >>I have searched the php.net and don't know where to look for the code Yes? - but you did not try searching with the keyword "date" or how? Even a search in Google with "php date" returns the manual's page with date() as first response... BUT the mysql-manual:

RE: [PHP] Easy Date & MySQL Question...

> I have searched the php.net and don't know where to look for the code I > need. I have a MySQL date column that reads this way: 2002-06-25. > However, > in PHP I want to show it this way 06/25/2002. Do the formatting in your query. Use the MySQL function DATE_FORMAT(). Look it up in the MySQL

Re: [PHP] Easy Date & MySQL Question...

as a quick hack you can use explode() to do this. try this: $date = explode("-",$mysqldate); echo $date[1]."/".$date[0]."/".$date[2]; - Original Message - From: "Doug Coning" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 3:06 PM Subject: [PHP] Easy Date & MySQL

Re: [PHP] Easy Date & MySQL Question...

Try looking at the date functions gmdate in the php.net manual B i g D o g - Original Message - From: "Doug Coning" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 9:06 AM Subject: [PHP] Easy Date & MySQL Question... > Hi everyone, > > I have searched t