MySQL Forums
Forum List  »  PHP

DATE problem
Posted by: npatsop
Date: August 22, 2005 04:20PM

I've made a table containing data and created a field called "lastupdate" to capture the last date any record was changed. I set the "lastupdate" to DATE allowing for NULL using phpMyAdmin-2.6.1.

When I retrieve the records with phpMyAdmin-2.6.1 I can see the "lastupdate" field to have the right value, e.g. 2005-08-23 if it was last changed at that date, but when I use <?php echo $row_people['lastupdate']; ?> to display this into a php file all i get is 0000-00-00.

Can anyone help me?

I use MySql 4.1.9 and Php 4.0

Options: ReplyQuote


Subject
Written By
Posted
DATE problem
August 22, 2005 04:20PM
August 23, 2005 08:10AM
August 25, 2005 01:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.