里的值如何用INSERT存入SQL数据库?

[guguda]

<select name="year">
<option>2003</option>
<option>2002</option>
<option>2001</option>
</select>

<select name="month">
<option>12</option>
<option>11</option>
<option>10</option>
</select>

<select name="day">
<option>1</option>
<option>2</option>
<option>3</option>
</select>
----------------------------------------
sql="insert into data (year,month,day) values ('????','????','????')"
这里的“？？？”要怎么写？

[guguda]

UP~~~~

[chinareny]

sql="insert into data (year,month,day) values ('" & request("year") & "','" & request("month") & "','" & request("day") & "')"
另外：你的select 需要这样写：
<select name="year">
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
</select>
即可

[Wocow]

chinareny说的对。