Try to get current date once for DATE column

3dron

Where do I apply this:

TIMESTAMP columns other than the first may also be set to the current date and time. Just set the column to NULL or to NOW().

If I set the column to NULL or put NOW() in the default value then date comes up 0000-00-00 upon record insert.

If I put a hidden field and submit 0000-00-00 I get same result.

So how do I just get date once upon record creation?

Thanks

chads2k2

Explain again what you are trying to do? I think people didn't understand what you are trying to do. Just let me / us know what you are attempting to do.

3dron

I just want the date "created" once, on record insert.

Not on update!!!

xblue

possibilities I can think of:

using more than one timestamp field will cause only the first one to be auto-updated (not very useful if you don't need the addition fields).
using date or datetime (no auto-updating)
setting the timestamp column to the value it previously had in your update statements with SET fieldname=fieldname