Don't reference the timestamp column at all in your INSERT (or future
UPDATE) statements and the timestamp should update just fine on its own.
i.e.
INSERT INTO Owners (NameID,ProductsKey,RegNum)
VALUES ('$NameID','1','$RegNumc');
BTW, you cannot change the default for a timestamp column - it is always
NULL (which displays as '00000000000000').
HTH,
--
coop
On Fri, 2001-12-14 at 15:16, Steve Osborne wrote:
>
> Timestamp additional info:
>
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
> VALUES ('$NameID','1','$RegNumc','NULL');
>
> ProdRegDate is the field that I want to timestamp. (Again, I've tried
> passing '', NULL, and 'NULL').
>
> Steve Osborne
> Database Programmer
> Chinook Multimedia Inc.
> [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
