RE: [PHP] Timestamp field update without changing anthing else?

Update your timestamp with a NULL and it'll update itself. -----Original Message----- From: strider@mail1.atl.bellsouth.net [mailto:strider@mail1.atl.bellsouth.net]On Behalf Of Strider Centaur Sent: 09 August 2000 08:18 To: php-general@lists.php.net Subject: [PHP] Timestamp field update without changing anthing else? Im trying to get a timestamp field to update in a record, but do not want to alter that record beyond that. This is a project tracking system and I want the last modified time of the project record to be updated when a task record is modified. I ask this because just doing an update like: $udts = "UPDATE notes SET timestamp=\"\" where ProjectIDNum=\"$referto\""; mysql_query($udts); does not have any affect on the timestamp. I know this is a MySQLism, but Im using PHP for all the code. :-) Anyway, if anyone out there has an idea, Id love to here it. -- Strider Centaur HTTP://www.Scifi-Fantasy.com " It is my observation that unless you really understand the issues, you are hardly in a position to criticize. Nearly all Linux users have used Windows, but very few Windows users have used Linux. " -- Me -- 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