Re: [PHP] Updating Timestamps

2001-11-26 Thread Ben Gollmer
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 us

Re: [PHP] Updating Timestamps

2001-11-26 Thread David Robley
On Tue, 27 Nov 2001 13:57, 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

Re: [PHP] Updating Timestamps

2001-11-26 Thread Kurt Lieber
This is more of a MySQL question than a PHP question, but... The TIMESTAMP format in MySQL isn't a read-only field -- you can update the data with your own timestamp information just like you can any other normal database field. So, simply create a timestamp using PHP and insert that into the

[PHP] Updating Timestamps

2001-11-26 Thread cosmin laslau
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