循环插入查询

Question

I have a form that is dynamically created/populated, I need to loop the results from that form into an INSERT query. What I have below works, however I need to add 6 more VALUES to the INSERT.

This works fine:

$query_Recordset3 = " INSERT  INTO temporder ( qnt, prod_id)  VALUES ";

foreach($_POST['qnt'] AS $prod_id  =>   $qnt){

 mysql_real_escape_string($query_Recordset3);
  $query_Recordset3 .= "('".$qnt."','".$prod_id."'),"; 

} 

$query_Recordset3 = substr($query_Recordset3,0,-1); 
$Recordset3 = mysql_query($query_Recordset3, $szabo)or die(mysql_error());  

Can someone offer a suggestion?

Edited

$query_Recordset3 = " INSERT  INTO temporder ( qnt, prod_id, ptype, mfg)      VALUES ";

foreach($_POST['qnt'] AS $prod_id  =>   $qnt)
foreach($_POST['ptype'] AS $ptype  =>   $ptype)
foreach($_POST['mfg'] AS $prod_id  =>   $mfg){

 mysql_real_escape_string($query_Recordset3);
      $query_Recordset3 .=                  "('".$qnt."','".$prod_id."','".$ptype."','".$mfg."'),"; 
}

This gets me 18 Inserts from 3 rows, plus the data is not correct.

I'm sorry, I'm used to only using this forum to read issues/solutions, first post. Thank you Gary