PHP - Is It Possible To Achieve What I Am Attempting?

I have a form which has both radio buttons and textfields. Each individual radio button is associated with a form field. For this example, lets say the Radio button references a tool name and the form field represents a quantity, or number of tools needed for a certain job. So the form would look as follows:

Quote

o Some Tool                Quantity ___ (<-- lets pretend thats a form field)



The question is, how would I go about adding the tool and quantity to the same row in the database if I am creating a new row? The simple way would be have each radio button and quantity be its own entity in the HTML. For example:

Code: [Select]
<input name="tool1" type="radio" value="Hammer" />
<input name="tool_quantity1" type="text" />

<input name="tool2" type="radio" value="Wrench" />
<input name="tool_quantity2" type="text" />
However easy this method may be, and however functional it may work, it is not how I wish to achieve this because we are talking maybe 100 tools. I think it would be easier using some kind of loop function that goes through an array of anything that has some form of data stored in it. For example, instead of the code being the above, I would like to change it to the following:

Code: [Select]
<input name="tools[]" type="radio" value="Hammer" />
<input name="tools_quantity[]" type="text" />
I understand the basic foreach function

Code: [Select]
foreach ($_POST['tools'] as $someVariableName) {
//do some stuff
}
But I don't understand how I can get the value of 2 different form fields and have them associated with one another. I want the tool and the quantity of tools to be stored in the same row. How is this done? Is this even possible using a loop function like foreach or while? Please help! As always, any help would be greatly appreciated!!

Bl4ck Maj1k