Hi Andy, > I have a timestamp in my table to store a date. Now I have to update other > columns and everytime I do this, the timestamp is updated as well. Is there > a other way then getting the value infront and storing it again?
If you have first read the row's data, UPDATE the timestamp field with the same/read data, then MySQL won't insert NOW() instead. Regards, =dn PS did you get an answer to your CA->Canada question? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php