Question

下拉框从数据库中取值并更新的问题

下面的注册的源码，里面有个多选的下拉框，不知道更新修改时这个程序中下拉框这块怎么写？

<form name=form1 onSubmit="return checkinput();" method="post" action="zclsok.asp">
<table width="85%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#B9DCFF" bgcolor="#F0F8FF">
<tr bgcolor="#CEE7FF">
<td width="15%" height="13">用户名</td>
<td width="52%">
<input type="text" name="teacher_name">
<font color="#FF0000">*</font> 汉字/字母/数字组成</td>
</tr>
<tr bgcolor="#CEE7FF">
<td width="15%" height="13">真实姓名</td>
<td width="52%">
<input type="text" name="teacher_namezhen" size="20"> <font color="#FF0000">*</font> 汉字</td>
</tr>
<tr bgcolor="#CEE7FF">
<td height="16">类 别：</td>
<td><font color="#FF0000">教 员</font></td>
</tr>
<tr bgcolor="#CEE7FF">
<td height="25"> 登陆密码：</td>
<td><input type="password" name="teacher_password">
<font color="#FF0000">* </font>大于6位小于15位</td>
</tr>
<tr bgcolor="#CEE7FF">
<td height="30">重复密码：</td>
<td><input type="password" name="teacher_password1">
<font color="#FF0000">* </font>和上面相同</td>
</tr>

<tr bgcolor="#CEE7FF">
<td>
<p align="center">服务区域</td>
<td><script language="JavaScript">
<!--
function moveOption(e1, e2){
try{
for(var i=0;i<e1.options.length;i++){
if(e1.options[i].selected){
var e = e1.options[i];
e2.options.add(new Option(e.text, e.value));
e1.remove(i);
i=i-1
}
}
document.form1.writefrom.value=getvalue(document.form1.list2);
}
catch(e){}
}
function getvalue(geto){
var allvalue = "";
for(var i=0;i<geto.options.length;i++){
allvalue +=geto.options[i].value + ",";
}
return allvalue;
}
//-->
</script>

<table border="1" width="100%" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#F0F8FF">
<tr>
<td width="222"><SELECT multiple name="list1" size="10" ondblclick="moveOption(document.form1.list1, document.form1.list2)">

Answer 1

<OPTION value="黄浦(人民广场/南京路/外滩)">黄浦(人民广场/南京路/外滩)</OPTION>

<OPTION value="黄浦(豫园/老西门/十六铺)">黄浦(豫园/老西门/十六铺)</OPTION>

<OPTION value="卢湾(淮海路/复兴路/建国路)">卢湾(淮海路/复兴路/建国路)</OPTION>

</SELECT></td>
<td width="59"><input type="button" value="添加" onClick="moveOption(document.form1.list1, document.form1.list2)"><br><br>
<input type="button" value="删除" onClick="moveOption(document.form1.list2, document.form1.list1)">
</td>
<td><select multiple name="list2" size="10" ondblclick="moveOption(document.form1.list2, document.form1.list1)">
</select> <input type="text" name="writefrom" size="40" style="border: 1px solid #CEE7FF; "> </td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#CEE7FF">
<td height="26" colspan="2"> <strong>重要联系方式</strong></td>
</tr>
<tr bgcolor="#CEE7FF"> <td height="30">家里电话：</td>
<td><input name="tel" type="text" >  </td>
</tr>
<tr bgcolor="#CEE7FF">
<td height="30">手机号码：</td>
<td><input name="mobile" type="text" size="20">
<font color="#FF0000">*</font></td>
</tr>
<tr bgcolor="#CEE7FF">
<td colspan="2"><div align="center">
<input type="submit" name="ok" value="提交" class="anniu">
<input type="reset" name="Submit" value="重写" class="anniu">
</div></td>
</tr>
</table>
</form>
</td>
</tr>
</table>