asp 修改求助。
<%dim sql,rs,thepage,currentpage,totalpage,n,pagename,page
city_oneid=HtmlEncode(trim(request("city_oneid")))
city_twoid=HtmlEncode(trim(request("city_twoid")))
city_threeid=HtmlEncode(trim(request("city_threeid")))
if city_oneid="" then city_oneid=0
if city_twoid="" then city_twoid=0
if city_threeid="" then city_threeid=0
if city_twoid=0 and city_threeid=0 then dcity="city_oneid="&city_oneid&""
if city_threeid=0 and city_twoid<>0 then dcity="city_oneid="&city_oneid&" and city_twoid="&city_twoid&"" 
if city_twoid<>0 and city_threeid<>0 then dcity="city_oneid="&ccty_oneid&" and city_twoid="&city_twoid&" and city_threeid="&city_threeid&""
if city_oneid<>0 and city_twoid=0 then city_id="&city_oneid="&city_oneid&""
if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then city_id="&city_oneid="&city_oneid&"&city_twoid="&city_twoid&""
if city_oneid<>0 and city_twoid<>0 and city_threeid<>0 then city_id="&city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid&""


if city_oneid=0 then
sql="select * from china_data where mark='yes' and stop >= date() order by money desc,[top] desc,time desc"
else
sql="select * from china_data where "&dcity&" and mark='yes' and stop >= date() order by money desc,[top] desc,time desc"
end if  
set rs=server.createobject("adodb.recordset")  
rs.open sql,conn,1,1  
if rs.eof then  
%>

这段代码显示的是全部分类，我想只选择一个分类，请高手指点怎么修改，谢谢了。

------解决方案--------------------
数据库的字段先搞明白了，哪个字段是类别，然后在SQL语句的Where部分修改

比如 select * from china_type where id=1

就是选取数据库中id=1的记录