Adding Dynamic Arrays to a Database

[whobutsb]

Hello,
Im having trouble adding dynamic input fields into my database. I created a form that has 5 input fields on it:

<tr id="row1">
	<td>
		 <input type="text" name="liquorname_1" id="liquor_name1" />
	</td>
	<td>
		 <input type= "text" name="liquortype_1" id="liquor_type1" /></td>
	<td>
		<input type="text" name="liquorprice_1" id="liquor_price1" />
	</td>
	<td>
		<input type="text" name="mixernotes_1" id="mixer_notes1" />
	</td>
	<td>
		<input type="text" name="liquornotes_1" id="liquor_notes1" />
	</td>
	<td>
		<a href="#" onclick="mooRemove(1);" title="Remove">Remove</a>
	</td>
</tr>

After the use has inputted all of their information they have the option to click a button that will add a new line of input fields but are incremented using javascript. name="liquorname_2", "liquortype_2", etc. My goal is to take these inputs and add them to a MySQL database or to create a HTML table that can be inserted into a text row in a database. Right now my output looks like this:

liquorname_1: Bacardi O
liquortype_1: Rum
liquorprice_1: 14.99
mixernotes_1: None
liquornotes_1: Disgusting Liquor
liquorname_2: Bombay Sapphire
liquortype_2: Gin
liquorprice_2: 24.99
mixernotes_2: Gin and Tonic
liquornotes_2: My Favorite Drink
liquorname_3: Ketel One
liquortype_3: Vodka
liquorprice_3: 27.99
mixernotes_3: Vodka Cranberry
liquornotes_3: None

I don't know how to iterate through the array and add each value independently to their respective database row.

I'm not asking for the full code solution just a quick pointer on the functions I should use. Thank you for your time!

[Kudose]

$array = range(1,100); // create array
foreach($array as $key => $value) // iterate array
  echo "Key $key holds the value $value <br />"; // display values

$array = $_POST;
foreach($array as $key => $value) // iterate array
  echo "Key $key holds the value $value <br />";

[whobutsb]

Thanks for the quick reply. I have been using the foreach statement to output my results. Is there a way to remove the ending "_#" from the $key so that I can just have either liquorname, liquortype, etc. So that I can use that as the identifier to input it into the database?

Thanks,
Steve

[leatherback]

Yes

Use an array in your form alread:

Define the field name as:
mixernotes[]

and the form wil return an array in your post:

$_POST['mixernotes'] = array(
0=> 'First set',
1=> 'Second set');
etcs

[whobutsb]

Awesome! That works great and it doesn't screw up the JS code. My one last question is when I output the code using:

foreach($_POST as $name => $value){

foreach($value as $output){

echo $name .": ";
echo $output ."<br />";
}
}

I Get:

liquorname: Bombay Sapphire
liquorname: Captain
liquortype: Gin
liquortype: Rum
liquorprice: 24.99
liquorprice: 25.99
mixernotes: Gin and Tonics
mixernotes: Rum and Cokes
liquornotes: My Favorite
liquornotes: Good Drink

Is there any way I can input each set so that the query would like like this?

$query = mssql_query("INSERT INTO tbl (name, type, price, mixer, notes) VALUES ('$liquorname_set1', '$liquourtype_set1', '$liquorprice_set1', '$mixernotes_set1', '$liquornotes_set1')");