Help!

[discostudio]

ok here goes:

I am using the following html code for my form:

<form>

<input type="text" name="batchupdate[][product_name]" value="product1">
<input type="text" name="batchupdate[][product_price]" value="4.99">
<input type="text" name="batchupdate[][upn]" value="2020">
<input type="text" name="batchupdate[][product_name]" value="product2">
<input type="text" name="batchupdate[][product_price]" value="8.99">
<input type="text" name="batchupdate[][upn]" value="2021">
<input type="text" name="batchupdate[][product_name]" value="product3">
<input type="text" name="batchupdate[][product_price]" value="12.99">
<input type="text" name="batchupdate[][upn]" value="2022">

</form>

Then the php code I am using is this:

if (isset($_POST['batchupdate']) && is_array($_POST['batchupdate'])) {

	foreach($_POST['batchupdate'] as $i) {

mysql_query("UPDATE `Products` SET 
`productname` = " . $i['product_name'] . ",
`productprice` = " . $i['product_price'] . " 
WHERE `upn` =  " . $i['upn']);
		 }

}

I understand I am looping through the array incorectly?

Needless to say it doesn't work, anyone got any ideas?

[thorpe]

Your kidding?

Please read the link in my signiture and come back when you can form a question.

[wilku]

I'd do this that way (maybe it doesn't work with 2d arrays?):

<form>

<input type="text" name="product_name[]" value="product1">
<input type="text" name="product_price][]" value="4.99">
<input type="text" name="upn[]" value="2020">
<input type="text" name="product_name[]" value="product2">
<input type="text" name="product_price[]" value="8.99">
<input type="text" name="upn[]" value="2021">
<input type="text" name="product_name[]" value="product3">
<input type="text" name="product_price][]" value="12.99">
<input type="text" name="upn[]" value="2022">

</form>

iif (isset($_POST['upn']) && is_array($_POST['upn'])) {

    foreach($_POST['upn'] as $key=> $i) {

mysql_query("UPDATE `Products` SET
`productname` = " . $_POST['product_name'][$key] . ",
`productprice` = " . $_POST['product_price'][$key] . "
WHERE `upn` =  " . $_POST['upn'][$key]);
         }

}

I haven't checked if such things work, but I hope it will help.

[discostudio]

thorpe wrote:

Your kidding?

Please read the link in my signiture and come back when you can form a question.

There's no need for that. I have searched the web and found nothing. I simply don't understand arrays and foreach and things.

Just asking for a little help, next time I won't bother.