two foreach to inset in database

[mraza]

Hi, I am stuck on this point for few hours please can someone help.

 

From one html form i am submitting two input boxes as array

<input type="text" name="names[]" />
<input type="text" name="position[]" />
<input type="text" name="names[]" />
<input type="text" name="position[]" />
<input type="text" name="names[]" />
<input type="text" name="position[]" />

Now when i submit i need to insert that values in a relational table

ID name position

 

I tried this way but dont know if i need to run two loops.

$names = $_POST('names');
$positions = $_POST('position');

// now here i dont know how i will insert in database
foreach ($names as $name) {
     foreach ($positions as $position) {
          $mysqlquery = ("INSERT into TABLE (name,position) values ($name,$position)");
}
}

 

Please any help how i will insert that

Thanks

[mraza]

$names = $_POST('names');
$positions = $_POST('position');
foreach($names as $row=> $name)
            {

	echo  $name . $positions[$row];	

		}

Solved