HI, how do you prevent a date (timestamp) column from updating when doing an update to that row. Everytime I perform an update to a row the NOW() function causes it to update to the current time..I don't want that to happen. Can anyone help....I'm sure there is a really easy solution to this.

thanks,
Dave

Hey section,

Well you could do this:

When you initialy put the information in the database just put in a timestamp instead of using the NOW() function.

like so:
$today=getDate();
$today[0]; // Returns UNIX Timestamp

In your mysql database just put $today[0] instead of NOW(). that should do it. Atleast thast what I do and it works for me hehe

What mysql datatype do u use. Would it work for me since i'm using the TIMESTAMP(14) datatype? This is not the same form as a unix timestamp...its in this form YYYYMMDDHHMMSS. Let me try and get back to you.

BTW, you don't need to do a getdate() if u just want a unix timestamp...just do a time(). Although the resources gained are neglible, its more efficient since thats all you want..

Nope i tried that, it didn't work. Does this mean I'm going to have to figure a way to format the date function using one of php functions in the exact format of the mysql timestamp...nooooooo...

I guess something like this will work right..

date("Ymdhis");

Well, i even tried that...and mysql still updates the d*** date field by itself....grrrrr...how the h*** do i fix this....i'm really p*****..hehe

How do you have your tables setup?

Well, i finally figured out a solution to this that never occured to me before...LOL

Why don't I just set the date equal to the previous value which works fine and as far as I know thats the only way to preven mysql from updating the date field.

Example, UPDATE table SET field1='field2' datefield=datefield;

horray.

Congrats!