* 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

Reply via email to