RE: [PHP] need help w/ sql query - update and select at once

-Original Message- From: Andrew McCombe [mailto:[EMAIL PROTECTED] Sent: 1. júlí 2003 23:33 To: [EMAIL PROTECTED] Subject: Re: [PHP] need help w/ sql query - update and select at once > Theoretically, you should be able to do a multi-table update since MYSQL > 3.23, like this: >

RE: [PHP] need help w/ sql query - update and select at once

Theoretically, you should be able to do a multi-table update since MYSQL 3.23, like this: UPDATE tablename, tablename2 SET tablename.field1 = 'yes' WHERE tablename.userid = tablename2.userid; I haven't tested it, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE