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 version please? UPDATE contacts, working SET contacts.lastactivity = working.date WHERE contacts.rcd = working.rcd I have asked my ISP if they have plans to upgrade, but need to get this system working urgently. John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]