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