RE: [PHP] multiple foreach

[Martin Towell]

try this...

for ($i = 0; $i < count($charge); $i++)
{
  $c = $charge[$i];
  $s = $size[$i];
  $sql = "UPDATE products_to_sizes SET surcharge = '$c'
WHERE product_id = '$products_id' AND size_id = '$s'";
mysql_query($sql) or die ("Couldn't update rows".MYSQL_ERROR());
  print $sql.'<br>';
}

-----Original Message-----
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 1:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP] multiple foreach


Maybe someone can see what I'm trying to do with this:

foreach($charge as $c){

foreach($size_id as $s){$sql = "UPDATE products_to_sizes SET surcharge =
'$c'
WHERE product_id = '$products_id' AND size_id = '$s'";
mysql_query($sql) or die ("Couldn't update rows".MYSQL_ERROR());
print $sql.'<br>';}
}

I get this:

UPDATE products_to_sizes SET surcharge = '1.50' WHERE product_id = '28' AND
size_id = '6'
UPDATE products_to_sizes SET surcharge = '1.50' WHERE product_id = '28' AND
size_id = '7'
UPDATE products_to_sizes SET surcharge = '3.00' WHERE product_id = '28' AND
size_id = '6'
UPDATE products_to_sizes SET surcharge = '3.00' WHERE product_id = '28' AND
size_id = '7'

I need to get rid of the two middle statements

Help!! :-)

-- 
Richard Whitney   *
Transcend Development
Producing the next phase of your internet presence.
[EMAIL PROTECTED]   *
http://xend.net    *
602-971-2791
  *     *       *
*  *      *__    *    *
         _/  \___  *
     *  /   *    \*    *
      */     * *  \
*    */\_         |\
     /   \_      /  \
    /      \____/    \
   /                  \ 
  /                    \
 /                      \


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php