* Paul DuBois > At 17:00 +0000 3/8/02, Corin Hartland-Swann wrote: [...] > >This works for a varying number of rows (usually 5,000 to 10,000) before > >it silently exits the loop. I'm using MySQL 3.23.49a [...] > > That's also your problem. With mysql_use_result, it's *required* > that you completely finish the query before issuing another one. > > I suppose you could write the IDs to a file, then read them back in > and use them to issue the UPDATE statements.
Why not make two connections, SELECT from one and UPDATE through the other? -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php