ok, i need some one whose brain works this way :p i have an inventory form. the form has a product name, COUNTED textbox, DELIVERED textbox, and COMP textbox. I have 29 products, each with these three textboxes that has to be filled out and submitted to a database. So, that means i have 29 x 3 form element fields, each with a unique id, that corresponds to a unique product at the end of the day, the boxes are filed with with the appropriate count for each box and then submitted. now, the insert statement is easy, basically: insert into inventory_count values ('product_id','Counted','Delivered','Comp').
so, if i haven't completely confused you, my question is, with a single table that has all 29 products on it, when i hit submit, how do i get it to loop through each product and insert the appropriate values for that product into the database? i cannot fill in and hit submit for each different product - i'll have new products in the future and want everything on one page.
thoughts? clarifications?
blue
