.="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
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?
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
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 migr