you probably cant ge this to work in PHP. try creating a temporary table -shiva
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 column called 'userid'. this column exists in both > tablename, and tablename2. where the value of userid in tablename is > equal to the value of userid in tablename2, i'd like to set the value of > field1 to 'yes'. > > can this be done from the command line? or am i better off writing > another php page to accomplish this? > > thanks again > redmond > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php