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.
Advertising
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 .. [EMAIL PROTECTED] .. [EMAIL PROTECTED] > >__________________________________________________ >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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
