I use foxpro to do similar loops
I've found that I get 10 queries per second on large tables, when connecting once, and issuing individual select statements via odbc.
It is much faster if you can narrow the recordset into an array within php, and spool through that, unfortunatly I deal with 250+ million rows, so hitting the table by a index one at a time is faster
Matt
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]