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

Reply via email to