problems with reading the array from a post

[toddring]

I am having a problem with readin an array that has been sent with a post.

in my form I have

<input name="name[]">
<input name="game[]">
<input name="winner[]">

in the processing of the form I can get the vars from the post using a foreach()
that gives me all of the name[] then all the game[] then all the winner[]

What I need is to get each line to input into the db such as

name[0], game[0], winner[0]

then move on to

name[1], game[1], winner[1]

Any help would be appreciated.

thanks Todd

[devinemke]

i suggest you reorganize how the data is grouped to make it easier to form your queries. a simple example:

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	1.<br>
	name: <input name="data[1][name]"><br>
	game: <input name="data[1][game]"><br>
	winner: <input name="data[1][winner]"><br>
	<br>
	2.<br>
	name: <input name="data[2][name]"><br>
	game: <input name="data[2][game]"><br>
	winner: <input name="data[2][winner]"><br>
	<br>
	3.<br>
	name: <input name="data[3][name]"><br>
	game: <input name="data[3][game]"><br>
	winner: <input name="data[3][winner]"><br>
	<br>	
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	foreach ($_POST['data'] as $key => $value)
	{
		$sql = "INSERT INTO table VALUES('" . $value['name'] . "', '" . $value['game'] . "', '" . $value['winner'] . "')";
		echo $sql . '<br>';
	}
}
?>

[toddring]

Thanks

Do I need to use the 1
name: <input name="data[1][name]"><br>
or can I do this

name: <input name="data[][name]"><br>
game: <input name="data[][game]"><br>
winner: <input name="data[][winner]"><br>

Thanks again

Todd