Incrementing array into HTML form element

matthewod

This issue may need to be posted on the database help too. I am trying to increment part of a form element from the number of rows from an sql query. Basically I have:

$num=mysql_num_rows($result);

for ($i=1; $i<=$num; $i++) {

$mv_quantity="mv_quantity$i";

}

Then I have the product display:

$products .="<tr><td>
<input name=\"$mv_quantity\" type=\"text\" size=\"1\" value=\"$quantity\">";

Where quantity is actully an output from the query. I have tried a few things to get this to work correctly, but I have not had a whole lot experience working with arrays like this. Basically I need mv_quantity to be +1 for every $num.

Thanks for any advice

devinemke

i would suggest a while loop rather than a for loop:

while ($row = mysql_fetch_assoc($result))
{
	echo '<input type="text" name="quantity[]" value="' . $row['quantity'] . '"><br>';	
}

this will return an array called $_POST['quantity'] with each quantity as the array values.

matthewod

devinemke,
thanks for the reply. I may not have been clear on what I am looking to do. $quantity is the array from the database, mv_quantity has to be incremented no matter what $quantity.

Here is a better example

Product A<input type=text size=3 name=mv_quantity1 value=$quantityA>
Product B<input type=text size=3 name=mv_quantity2 value=$quantityB>
Product C<input type=text size=3 name=mv_quantity3 value=$quantityC>
Product D<input type=text size=3 name=mv_quantity4 value=$quantityD>
Product E<input type=text size=3 name=mv_quantity5 value=$quantityE>

I am getting the Product and $quantity from the query, but I need to increment the mv_quantity for each Product.

thanks for your help.

Matt

devinemke

my suggestion was, rather then giving each form field a unique name, mv_quantity*, have the form return an array of quantities. if the product has a unique ID number then use that as the array keys.

matthewod

devinemke,
thanks again for your reply. The product ids have numbers and letters in the sku. The shopping cart program I am posting to, Interchange, will only, as it appears, recognize mv_quantity1, mv_quantity2, for adding mulitple items to the shopping cart. So this way I need to increment this for ever item that is being added to the shopping cart.

Thanks
Matt

devinemke

$i = 1;
while ($row = mysql_fetch_assoc($result))
{
    echo $row['product_id'] . '<input type="text" name="mv_quantity' . $i . '" value="' . $row['quantity'] . '"><br>';
		$i++; 
}

matthewod

devinemke
Hey that works!! Thanks for your help!! That is exactly what I needed.

Matt