Shopping List Help

[moonman239]

Hi,

I am working on a Web site that tells you how to build electrical devices. Every page telling the user how to build an electrical device has a categorized list of things to add to the shopping list. I want to have checkboxes next to the categorized items. My problem is I don't know how I can add the quantities to a MySQL database (I set the quantity field to NOT NULL).

Thanks,
moonman239

BTW: If you are guessing I am using PHP, you're right.

[RudiVisser]

Ummm,

UPDATE `table` SET `quantity` = '$quantityVar' WHERE `item_id` = '$itemID' LIMIT 1;

?

EDIT: Please (next time, this time even!) give us some context to work in. ie. surrounding code around where you want to update the field

[moonman239]

Well I want PHP to generate the shopping list when the browser requests a page telling the user how to build the machine. Is there any way I can do it while only typing whatever's needed once?

BTW: Thanks for your generous help as far as the quantity is concerned. I will just be sure the PHP page involved enters the quantity. I am not going to reveal the code for the page that tells the user how to build the machine because I don't want THAT page to add to the list, I want the page that lists the tutorials on building machines to add to the list.

Unless, of course, it's the only way possible.