Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread bbonkosk
>From the MySQL Manual: The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. If YOU want control over this, us the DATETI

Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Paul DuBois
At 11:59 -0500 9/11/02, Rob Day wrote: >Hi all, >I have a table in MySQL with the following field: > 'time_date' timestamp(14) NOT NULL >When a record is inserted into the table, NULL is inserted into the >time_date field giving me a normal timestamp with the time of the INSERT. >That much i