Re: Looping advice sought

Good morning George, As always, it depends on the data. Knowing how large your queriesare, can you give us a stripped down example of two iterations? Not code, just an example of what you're wanting to update or insert. Miles At 11:24 AM 1/22/2002 +0000, George Pitcher wrote:

Hi all, I am about to start on a script page which will loop thru a MySQL table and update records depending on the actions of the user. I propose to loop through, row by row performing a separate UPDATE statement for each row, unless someone can advise me of a better way (2d array?). I am migrating this site from Lasso where I needed to to do two iterations of the script: the first handles a single row input and the other handles multiple row inputs. Do I need to do two with php or will one be able to handle a count of 1 in a loop just as well as a multiple count? MTIA George ===== George Pitcher Technical Manager, HERON, Napier University, Edinburgh 0131-455 2435 .. fmdev@yahoo.co.uk .. safc2_1nufc@yahoo.com __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net