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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to