Miles,
It's not as bad as some of my queries. Here's my code
so far:
= = = = = =
$i=1;
while $i<($howmany + 1)
{
$activity=($activity . $i);
$tr_id=("$tr_id" . $i);
if($activity<>'' and $activity<>'Delete' and
$activity<>'Submit'){
if($activity=='Decline')
$activity='Declined';
if($activity=='Withdraw')
$activity='Withdrawn';
$uquery1 ="update Transactions ";
$uquery1.="SET (PHEIAction, PHEIAccepts) "
$uquery1.="VALUES "
$uquery1.="('$activity', '$d1') "
$uquery1.=" WHERE RecID= '$tr_id'"
mysql_query($uquery1);
}elseif($activity=='Submit' or $submit=='Submit Whole
Pack'){
$uquery1 ="update Transactions ";
$uquery1.="SET (PRequestsubmitted, Packorder)"
$uquery1.="VALUES "
$uquery1.="('$d1', '$Packorder')"
$uquery1.=" WHERE RecID= '$tr_id'"
mysql_query($uquery1);
}elseif($activity=='Delete'){
$uquery1 ="update Transactions ";
$uquery1.="SET CourseID "
$uquery1.="VALUES "
$uquery1.="0"
$uquery1.=" WHERE RecID= '$tr_id'"
mysql_query($uquery1);
}
= = = = = =
George
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 11:49 AM
Subject: Re: [PHP-DB] 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 +, 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]