Re: [PHP-DB] update and join?

2002-10-10 Thread Thomas Lamy
Cory Hicks [mailto:[EMAIL PROTECTED]] wrote: Hello to all! Quick questionis it possible to do an update query w/ a join yet? If not, what is your preferred method? Would you take care of it on the PHP side? No, it's not possible, at least not with MySQL 3.x. MySQL 4.1, currently in

RE: [PHP-DB] update and join?

2002-10-10 Thread John W. Holmes
Quick questionis it possible to do an update query w/ a join yet? If not, what is your preferred method? Would you take care of it on the PHP side? Probably depends on your database, but MySQL doesn't support it. I think MySQL 4.0 might. I need to update a table w/ data from another