you probably cant ge this to work in MySQL. try creating a temporary table
"Shivanischal A" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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