Dbmier LED Artcraft Tracing Light Pad Light Box Light Board Light Table- A4

PHP Tech Blog

Dbmier LED Artcraft Tracing Light Pad Light Box Light Board Light Table- A4

留言簿(5)

Links

My Favorites

推荐技术文章

阅读排行榜

评论排行榜

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);
                }

posted on 2009-11-02 18:22 haix 阅读(2444) 评论(0)  编辑 收藏 引用 网摘 所属分类: MYSQL


只有注册用户登录后才能发表评论。
网站导航:
Dbmier LED Artcraft Tracing Light Pad Light Box Light Board Light Table- A4