Re: Looping advice sought
| From: | George Pitcher | Date: | Tue, 22 Jan 2002 12:10:51 +0000 |
| Subject: | Re: Looping advice sought | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16047@lists.php.net to get a copy of this message | ||
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" <milesthompson@ns.sympatico.ca>
To: "George Pitcher" <fmdev@yahoo.co.uk>;
<php-db@lists.php.net>
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 +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 .. fmdev@yahoo.co.uk .. safc2_1nufc@yahoo.com
__________________________________________________
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