On Sunday 03 February 2002 03:47, Todd Williamsen wrote:
> I want the date to automatically be updated. So if a post was made on
> 2/10/2001 I would like it to put it automatically in the database.
>
> I do have a column called "Date" and the datatype is set to date. But when
> I add a record even if the sql states to insert the date it doesn't, or
> does the date need to be manually added?
Use a field of the type "Timestamp" -- it updates automatically whenever the
record is updated.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
The only difference in the game of love over the last few thousand years
is that they've changed trumps from clubs to diamonds.
-- The Indianapolis Star
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
