List Box Question

KrisCons

Hi all,

I would like to know how I would go about doing the following:

I already have a query which retrieves data and displays the info on rows on my screen, and for each row i have a drop down menu with 3 different values.

What I would like to do is allow the user to pick any row and change the value in the list box and then click update which inserts that value into a table.

Could someone please advise on what the best route would be?

Cheers

devinemke

pass the list boxes as an array to the form processor using the primary key fileds as the array keys. for eaxample (id # 123):

<select name="adjustment[123]">
<option value="0">(Nil)</option>
<option value="1">25%</option>
<option value="2">50%</option>
</select>

then in the form processor loop thru $POST['adjustment'] and do the updates:

foreach ($_POST['adjustment'] as $key => $value)
{
	$sql = "UPDATE table SET field = '$value' WHERE id = $key";
	// do the query
}