Visit Shenzhen, Shenzhen China, Shenzhen Travel Guide

Shenzhen Universiade - Shenzhen 2011 Summer Universiade

统计

留言簿(2)

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 阅读(781) 评论(0)  编辑 收藏 引用 网摘 所属分类: MYSQL


只有注册用户登录后才能发表评论, 未注册用户请先注册

网站导航:
Shenzhen Universiade - Shenzhen 2011 Summer Universiade