Loop over form values & insert into db

Form

prod_id     prod_name       prod_price    prod_status
001         product 001     1.00          1            
002         product 002     2.00          1      
003         product 003     3.00          0      
004         product 004     4.00          0      

Form Dump
prod_name      product 001,product 002,product 003,product 004
FIELDNAMES     prod_id, prod_name, prod_price, prod_status
prod_price     1.00,2.00,3.00,4.00
prod_status    1,1,0,0
prod_id        001,002,003

I want to update a few fields, prod_price and prod_status. I submit these values to my update page but I'm not sure how to loop over these values and update by the prod_id. In my update page I'm using cfdump and I see the structure of the form, the fieldnames as well as the prod_id, prod_name, etc and their values.

My question is how do I loop over these form values so I'll be able to update by each prod_id? I've played around with looping over the form collection values but no luck.