OK I have asked the question before and not really gotten the answer, so
I will re-word what I am trying to do.
First I figured out that part of my problem may be how I am storing the
date into mysql from php.
Currently we are using the now() function to store the date in one field
and the time in another. I know understand what is physically being
stored in the db.
I am trying to retreive the date value from the mysql db, and display it
on the screen in a standard format like 05/08/01.
What I get right now is 2001-05-09.
Also the time comes out like so: 227:08:22
I have tried this:
$t_data_array[1]=date("m/d/y",mysql_result($db_result,$db_record,'date'));
and the result is: 12/31/69 formatted nicely but that date is 5/9/2001
not 1969.
I have tried several suggestions and other things, but I am not being
successful.
Here is what I am trying to do:
I would like the result of the date to be formatted as 05/01/01
and the time as 18:51
Please give me some very specific instructions, this is a silly thing to
be stuck on...
$t_data_array[1]=mysql_result($db_result,$db_record,'date');
$t_data_array[2]=mysql_result($db_result,$db_record,'time');
THANKS !
___________________________________________________________
Jack Sasportas
Innovative Internet Solutions
Phone 305.665.2500
Fax 305.665.2551
www.innovativeinternet.com
www.web56.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]