Thanks, it is working perfectly as described....
Steve > 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 >> > 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