phleft.asp

本实例为一个完整的网上购物商城的完整例子程序,里面有所以的源代码.希望对大家学习有用.

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0">

<tr>
<td height="40">
<div align="right">
<select name="select" onchange="var jmpURL=this.options[this.selectedIndex].value ;if(jmpURL!='') {window.location=jmpURL; }else{ this.selectedIndex=0; }" >
<option value="" selected>- 选择分类 -</option>
<option value="shop_ph.asp">商品总体排行</option>
<%
set rsts=server.createobject("ADODB.Recordset")
sqlts="select * from sort order by sort_id"
rsts.open sqlts, conn, 1, 1
while not rsts.eof
%>
<option value="shop_ph.asp?sort_name=<%=rsts("sort_name")%>"><%=rsts("sort_name")%>类排行</option>
<%
rsts.movenext
wend
rsts.Close
set rsts=nothing
%>
</select>
</div></td>
</tr>
</table>