how to insert a current_timestamp when an update is performed.

[eluser]CroNiX[/eluser]
I like to be able to use the built in date/time functions mysql offers without having to do a bunch of extra bloated conversions from unix timestamp to mysql timestamp. If you use a unix timestamp, you can't use built in functions like the one I posted above without extra sql to convert, so you'd also have to manually create it on insert and manually update it. I think it's just much simpler, uses less code and keeps this stuff out of php and lets the db handle it, which is more optimized for this task as they provide more specific functions to handle date/time calculations within sql.