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

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 i