At 12:18 -0800 2001/12/14, 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
Hi Steve,
You don't need to (and shouldn't) specify the timestamp field in your query at all. If
it's defined in the table, it'll update automatically when you insert or update the
record.
In the example above, you're specifically setting it to NULL or an empty string --
it's taking it's best shot, and filling the column with '0's. :>
HTH
/Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
"Life's unfair - but root password helps!"
---------------------------------------------------------------------
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
