I'm having a problem looping through my form items and inserting the data. My code looks something like this:
<form action="action.cfm" method="post">
<input type="text" name="Name1" value="Jimmy">
<input type="text" name="Number1" value="33">
<input type="text" name="Name2" value="Fred">
<input type="text" name="Number2" value="43">
<input type="text" name="Name3" value="Amy">
<input type="text" name="Number3" value="65">
<input type="text" name="Name4" value="Dan">
<input type="text" name="Number4" value="76">
</form>
My action page needs to loop through the items and enter each form item into the database fields "Name" and "Number". Any help?
<form action="action.cfm" method="post">
<input type="text" name="Name1" value="Jimmy">
<input type="text" name="Number1" value="33">
<input type="text" name="Name2" value="Fred">
<input type="text" name="Number2" value="43">
<input type="text" name="Name3" value="Amy">
<input type="text" name="Number3" value="65">
<input type="text" name="Name4" value="Dan">
<input type="text" name="Number4" value="76">
</form>
My action page needs to loop through the items and enter each form item into the database fields "Name" and "Number". Any help?