Re: Join question [solved]
| From: | tedd | Date: | Sat, 01 Dec 2007 03:00:19 +0000 |
| Subject: | Re: Join question [solved] | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-265337@lists.php.net to get a copy of this message | ||
At 2:00 PM +1100 11/30/07, Chris wrote:
Yes, that was true. But considering that it no longer worked, I moved on. I still have no clue as to why four months ago the code ran and now it doesn't -- other than the host upgraded. But, I don't see how that could have affected things. As for MySQL version, it's now 3.23.58 -- but I don't know what it was before the upgrade -- could have been the same. I dunno. Thanks for the interest. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.comOut of curiosity, what SQL server (and version) are you using? I currently have MySQL 5.0.33 on my dev box and I had no problem with the query I gave you. Perhaps it's a version issue. There really shouldn't be a problem updating a table that also occurs in the select query since the select query should take place before the insert.He wasn't doing an insert/select, he was doing an update with two tables joined together. <copy> I thought that -- UPDATE user1 u1, user2 u2 SET u1.login = u2.login, u1.password = u2.password WHERE u1.username = u2.username -- would work, but it don't.