Re: updating multiple records
| From: | Chris | Date: | Wed, 02 Aug 2000 22:52:35 +0000 |
| Subject: | Re: updating multiple records | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-9842@lists.php.net to get a copy of this message | ||
I don't think you can have $result specified outside of the loop since it
will be set with the initial value of $i which would be 0 or null.
Try moving: $result = mysql_query( "SELECT * from Clients WHERE
Client_ID='$Client_ID[$i]' ");
after for($i=0; $i<$last;$i++); and before while($row =
mysql_fetch_row($result)) {
>
> $result = mysql_query( "SELECT * from Clients WHERE
> Client_ID='$Client_ID[$i]' ");
>
> $CID=array();
> $Dy= array();
> $last=count($CID);
> for($i=0; $i<$last;$i++);
> while($row = mysql_fetch_row($result)) {
> $CID[] = $row[0];
> $CLN = $row[1];
> $CLC = $row[2];
> $RC = $row[3];
> $RE = $row[4];
> $CLE = $row[5];
> $RP = $row[6];
> $CLP = $row[7];
> $IN = $row[8];
> $Mn = $row[9];
> $Dy[]= $row[10];
> $Yr = $row[11];
>
>
> }
>
> and then I have the form with text fields to echo the current data. My
> query statement is not working and I'm sure it's obvious to most of you
why
> it isn't. Would one of you be kind enough to please enlighten me?
>
> TIA, Cory
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net