sql="select * from [A] order by Aid desc"
sql="select * from [A] where BID=“&BID&”order by Aid desc"
sql="select * from [A] where CID=“&CID&”order by Aid desc"
访问index.asp
就读出全部记录
当访问 index.asp?BID=BID
就读出 BID 的记录
当访问 index.asp?BID=BID&CID=CID 就读出 CID的记录啊
简单的说 sql="select * from [A]" if bid<>"" and bid<>null and cid="" then sql=sql&" where bid="&bid if cid<>"" and cid<>null then sql=sql&" sql=sql&" where CID=“&CID sql=sql&" order by Aid desc" ……
IP卡
狗仔卡
发表于 2010-1-18 03:35:33
收藏
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡