<script> function move(fbox,tbox) { var i = 0; if(fbox.value != "") { var no = new Option(); no.value = fbox.value; no.text = fbox.value; tbox.options[tbox.options.length] = no; fbox.value = ""; } } function remove(box) { for(var i=0; i<box.options.length; i++) { if(box.options[i].selected && box.options[i] != "") { box.options[i].value = ""; box.options[i].text = ""; } } BumpUp(box); } function BumpUp(abox) { for(var i = 0; i < abox.options.length; i++) { if(abox.options[i].value == "") { for(var j = i; j < abox.options.length - 1; j++) { abox.options[j].value = abox.options[j + 1].value; abox.options[j].text = abox.options[j + 1].text; } var ln = i; break; } } if(ln < abox.options.length) { abox.options.length -= 1; BumpUp(abox); } } function Moveup(dbox) { for(var i = 0; i < dbox.options.length; i++) { if (dbox.options[i].selected && dbox.options[i] != "" && dbox.options[i] != dbox.options[0]) { var tmpval = dbox.options[i].value; var tmpval2 = dbox.options[i].text; dbox.options[i].value = dbox.options[i - 1].value; dbox.options[i].text = dbox.options[i - 1].text dbox.options[i-1].value = tmpval; dbox.options[i-1].text = tmpval2; } } } function Movedown(ebox) { for(var i = 0; i < ebox.options.length; i++) { if (ebox.options[i].selected && ebox.options[i] != "" && ebox.options[i+1] != ebox.options[ebox.options.length]) { var tmpval = ebox.options[i].value; var tmpval2 = ebox.options[i].text; ebox.options[i].value = ebox.options[i+1].value; ebox.options[i].text = ebox.options[i+1].text ebox.options[i+1].value = tmpval; ebox.options[i+1].text = tmpval2; } } } </script> <form ACTION="" METHOD="post"> <table align="center"> <tr> <td> <select name="list1" size="1"> <option value="祝寿" selected>祝</option> <option value="生日">生日</option> <option value="亲朋好友">好友</option> <option value="办公室">办公</option> <option value="家具装饰">装饰</option> <option value="酒店">酒店</option> <option value="公关馈赠">馈赠</option> <option value="开张庆典">庆典</option> </select> </td> <td> <input type="button" value="添加" onclick="move(this.form.list1,this.form.list2)" name="B1"><br> <input type="button" value="删除" onclick="remove(this.form.list2)" name="B2"><br> <br> <input type="button" value="上移" onclick="Moveup(this.form.list2)" name="B3"><br> <input type="button" value="下移" onclick="Movedown(this.form.list2)" name="B4"> </td> <td> <select multiple size="7" name="list2" id="Select1"> <option value="one">1</option> </select> </td> </tr> </table> </form>

以上语句是一个多选框，请问我用什么样的sql语句才能吧list2里我选择的东西循环插入数据库表呢？谢谢！