RE: [PHP-WIN] update?'

I doubt there is any way to do this without using an intermediate step. I would grab all the data you need from whichever tables you are grabbing from, into a temporary array in PHP, including whatever keys you are using to place them into the other table where they are being placed. Then go back through that array, running one or more UPDATE query for each row, putting the data where it belongs. -Mike At 12:36 PM 4/5/02 +0100, Sandeep Murphy wrote:

hi, sorry for missing out on the database type.. am using Mysql 3.23... am trying to execute this query in query analyzer (Mascon) directly...