Working with CURRENT_TIMESTAMP

[eluser]codemonkey[/eluser]
Yacman, I see what you are saying. I didn't think of it like that. Using the profiler helps with this too since I can copy the query in mysql and see what that returns. So I have the tools to play and test.

I really was just unsure on how to use the information in the column. How to format the query the correct way.

Correct me if I’m wrong (really late here), but isn’t

The data type is timestamp, default is CURRENT_TIMESTAMP

mean that any time you update a row for a user their “date_created” field will be updated to a new timestamp… this field/column should really be a “date_time”, and create a new column called “last_update” with a timestamp datatype….

Yes and no, I think it would depend on how the data is being inserted. For this table, each new entry is a new row with a new time stamp.