Go through records in database based on submitted form data

I have a table containing products and I have a form which lists all those products with a number input next to each one. The visitor then enters numbers next to each one and submits the form.

I want the Server Connect API script to do all the work. It should receive the form and then look up each product to get a value and add that to a running total.

I’m thinking the easiest way is to put in a Repeat to cycle through the post variables and do a single record query each time to get the value each time. But that seems very poor in terms of server load. So I’m thinking it should be better to load all the data into something like an array and then call on that in the repeat.

Is that the way to go or is there a better method?