I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In response to Mikel, the field is declared as NULL and default is NULL. I've experimented with changing the Null and Default columns in phpMyAdmin, but it stays as NULL and default as NULL.
Steve. > > Steve Osborne wrote: > > > > > Rick, > > > > <snip> > > Just add a field of type TIMESTAMP to your record. Whenever the field is > > added or updated, this field will be updated as well. > > </snip> > > > > The field is already a 'timestamp(14)' type field, but all that is being > > stored in the fields are zero's. > > > > Do you know what could be causing this? > > > > Steve > > mysql (filter filter) > > > Yes, you are putting something there, and it is not a valid datetime, > so Mysql substitutes 0s. > > > > --------------------------------------------------------------------- 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
