Re: Updating Timestamps

The easiest way is to use an SQL query like this; update your_table set timestamp_field=null; This sets the timestamp to the current time automagically. You can of course add a where clause and so on to this query. Ben On Monday, November 26, 2001, at 09:27 PM, cosmin laslau wrote:

I'm using timestamps (God bless the little things) to keep track of database updates, so to give users the latest updates by the second. Kinda neat. But anyway, the timestamps are in one table, and when something is that table is changed, it automatically updates. However, I have another table which I want to affect the timestamps. Is there a command for 'manually' updating a timestamp rather than by SQL's own logic? Thanks in advance. Cosmin Laslau _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net