OurMySQL

mysql中如何用mysql_query()一次执行多个insert语句？

不支持，必须一次一次执行

               $formatid = mysql_insert_id();

                $count = count($_POST['FieldSeq']);

                for($tmp=0;$tmp<$count;$tmp++)
                {
                    $subSQL= “INSERT INTO tblAddrFormatDtl SET “;
                    $subSQL.=”FormatID=”.$formatid.”,”;
                    $subSQL.=”FieldSeq=”.$_POST['FieldSeq'][$tmp].”,”;
                    $subSQL.=”FieldName=’”.$_POST['FieldName'][$tmp].”‘,”;
                    $subSQL.=”OutputSeq=”.$_POST['OutputSeq'][$tmp].”,”;
                    $subSQL.=”ParentField=’”.$_POST['ParentField'][$tmp].”‘,”;;
                    $subSQL.=”ListCode=’”.$_POST['ListCode'][$tmp].”‘,”;
                    $subSQL.=”EntryFlag=”.$_POST['EntryFlag'][$tmp].”,”;
                    $subSQL.=”NewLine=”.$_POST['NewLine'][$tmp].”;”;
                    mysql_query($subSQL);
                }