Re: Timestamp field update without changing anthing else?

On 8 Aug, Strider Centaur wrote: > 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. > Try updating the record using its current value to update, but don't touch the timestamp field. Cheers -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA