foreach+array=problem...

[Johan Beijar]

Dear all,

I have problems with a Foreach-statement...and I hope someone can help me...

I take the
$assortquant = $HTTP_POST_VARS['assortsizequant']; from a form-page.

I then retrieve data from the DB:
$assortsize = mysql_fetch_array($resultassortsize);.


exampel:

assortsizequant assortsize

1 37
2 38
2 39
3 40
2 41
1 42

I would then like to insert this info into the assort_quant_value-table with a foreach-statement and this is where I run into problems...

The quantity (assortsizequant) is inserted correctly into the DB but the assortsize is not. I only get the number 3 into the DB where it should say 37-42.

Can anyone guide me...?

Thank you,

Johan Beijar



<?
include("include/session.php");
error_reporting(E_ALL);
$query = mysql_query ("INSERT INTO Assortment_product (assortment_id, productid, username) values (NULL, " . $_SESSION['prodid'] . ", '$session->username')") or
exit(mysql_error());
$result = mysql_query($query);
//get last inserted ID
$lastassortid=mysql_insert_id();
//Insert quantity of each size per product into value_assortment-table
//get the value_id and them store in a array
$resultprodname = mysql_query("SELECT productname, productid FROM products WHERE productid = {$_SESSION['prodid']} and username='$session->username'");
$prodname = mysql_fetch_array( $resultprodname );
$prodid=$prodname['productid'];
$resultassortsize = mysql_query
("SELECT
attribute_values.value_id
FROM
attribute_values,
product_attributes
WHERE
product_attributes.username = '$session->username' and
attribute_values.value_id = product_attributes.value_id and
product_attributes.productid = ".$prodid." and
attribute_values.attrib_id = 1")
or die(mysql_error());
$assortsize = mysql_fetch_array($resultassortsize);
//Get the quantity from the assortment_add.php-page.
$assortquant = $HTTP_POST_VARS['assortsizequant'];
$i=0;
foreach ($assortquant as $assqt)
{
$assortins=mysql_query("
INSERT INTO assort_quant_value
(quantity, value_id)
values
(
" .$assqt. ",
" .$assortsize['value_id']['$i']. "
)") or
exit(mysql_error());
$i++;
}
header("Location: assortment_add.php");
?>

[Nile]

can you be a bit more clearer on what you want? I get your problem, just not what you want.

[Johan Beijar]

Sorry...

I would like:

assortsizequant assortsize

1 | 37
2 | 38
2 | 39
3 | 40
2 | 41
1 | 42

To be inserted instead of

1 | 3
2 | 3
2 | 3
3 | 3
2 | 3
1 | 3

I hope this clarifies it...

Should I use
$assortsize = mysql_fetch_row($resultassortsize);
instead of
$assortsize = mysql_fetch_array($resultassortsize);
?


/Johan

[JazzcatCB]

Hi Johan,

Your problem may be here:



" .$assortsize['value_id']['$i']. "


Try this instead:


" .$assortsize['value_id'][$i]. "


I hope that helps.