I have spent all day working on a PHP/MySQL system offline using MySQL
version 4.0.15-nt. One particular SQL statement that works perfectly
wouldn't work when I uploaded it to my web site. It seems that my ISP
is using version 3.23.56, and I have written a SQL statement that will
only work on 4.04 or later.
Can someone suggest how I can rewrite the following to work on the old
UPDATE contacts, working SET contacts.lastactivity = working.date WHERE contacts.rcd =
I have asked my ISP if they have plans to upgrade, but need to get
this system working urgently.