ÕâÑùµÄSQLÔõôÀ´±í´ï°¡

Secret

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µÄ¼Ç¼°¡

aiqŸoÄÎtx

¼òµ¥µÄ˵ 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" ¡­¡­