Getting results from one loop into another loop

[micmac]

Hi all,
Having troble with the following loop.
This is what i have:

foreach ($_SESSION['cart'] as $isbn => $qty){
$sql_charge = "select * from movie where movie_id='$isbn' AND movie_ship_charge='yes'"; 
$result_charge = mysql_query($sql_charge); 
while ($row = mysql_fetch_array($result_charge)){
echo "$qty,";
}
}

The following correctly outputs the array of "1,2,"
I'm only echoing the $qty for testing.
What i'm wanting to do now is get the values returned from $qty and use them in the following query. This is where i am having trouble.
The following query looks like:

$pSQL = "select pcRate from postalcharges WHERE pcCountryID='14' AND pcShipType='1' AND pcWeight='$qty'";
$pSQL_result = mysql_query($pSQL); 
while ($row = mysql_fetch_array($pSQL_result)){ 
$pcRate = $row['pcRate'];
}

Assuming the results for $qty from the first loop, eg. 1 and 2, how do i get these values into a loop using the above query?

Cheers,
micmac

[dankstick]

foreach ($_SESSION['cart'] as $isbn => $qty){
 $sql_charge = "select * from movie where movie_id='$isbn' AND movie_ship_charge='yes'"; 
 $result_charge = mysql_query($sql_charge); 
 while ($row = mysql_fetch_array($result_charge)){
  $pSQL = "select pcRate from postalcharges WHERE pcCountryID='14' AND pcShipType='1' AND pcWeight='$qty'";
  $pSQL_result = mysql_query($pSQL); 
  $row2 = mysql_fetch_array($pSQL_result);
  $pcRate[$isbn] = $row2['pcRate'];
 }
}

You have two arrays at the end of this, one is the original
$_SESSION['cart'][isbn] = //some quantity, 1,2

and another

$pcRate[isbn] = //rate from database above

I took the while loop out of the second query because it should only return one result
for each $qty, right?

echo a var_dump($pcRate) after this just to see if rates came through.

[micmac]

Thanks for the reply dankstick,
This it what it returned:

array(2) { [2742]=> string(3) "1.5" [1968]=> string(3) "2.5" }

I also got the following error:

Fatal error: Unsupported operand types in /home/httpd/vhosts/dvdrealm.com.au/httpsdocs/cart_4.php on line 470

this is line 470:

$ordShipping = number_format($pcRate+$reg_post, 2, ".", ",");

Does that give you any more ideas?

Cheers,
micmac

[dankstick]

I see...

array(2) { [2742]=> string(3) "1.5" [1968]=> string(3) "2.5" }

The array above is the ISBN as the key and the shipping price per each as the value. I guess your code needs the total price, try this line right after the code I gave earlier....

$pcRate = array_sum($pcRate);

if you needed it into an organized array mine would work....

[micmac]

ahh dankstick, thankyou so very much...that worked a treat.

Have a good weekend,
micmac