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

PROTECTED] Sent: 1. júlí 2003 02:33 To: [EMAIL PROTECTED] Subject: [PHP] need help w/ sql query - update and select at once hi i'm trying to get this sql query to work, i'm trying to update and select at the same time, i'm not even sure if this is even possible update db.tablename set field1='yes

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: UPDATE

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

hi i'm trying to get this sql query to work, i'm trying to update and select at the same time, i'm not even sure if this is even possible update db.tablename set field1='yes' where (select * from db.tablename,db.tablename2 where db.tablename.userid=db.tablename2.userid); basically i have a