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
