Use the following to format date&time values:

<?echo date('Y-m-d',strtotime('2004/01/01'));?>

http://www.php.net/date

send your code if still unsure...



-----Original Message-----
From: Ahmed Sarwar [mailto:mysqldba-ezmlmshield-x65322948.[Email address protected]
Sent: Monday, July 04, 2005 11:23 AM
To: LazyDBA Discussion
Subject: PHP mySQL

Hello,

I have a PHP code and it shows the time (HH:MM:SS) but, the "MM" never

changes, it always stays at "07". Does anyone know how to make it

show the current time. Thanks in advance.



Ahmed



PS. I will send the code if anyone is interested.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com



MySQL LazyDBA home page