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.


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?
>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
>PHP Database Mailing List (
>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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to