Re: [PHP-DB] Looping advice sought

2002-01-22 Thread George Pitcher
.="SET CourseID " $uquery1.="VALUES " $uquery1.="0" $uquery1.=" WHERE RecID= '$tr_id'" mysql_query($uquery1); } = = = = = = George - Original Message - From: "Miles Thompson" <[EMAIL PROTECTED]> To: "George Pitche

Re: [PHP-DB] Looping advice sought

2002-01-22 Thread DL Neil
George, > 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?

Re: [PHP-DB] Looping advice sought

2002-01-22 Thread Miles Thompson
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 +, George Pitcher wrote: >Hi all, > >I am