<%
if request("key")<>"" then
dim com_sql
session("key") =request("key")
session("xtype") =request("type")
if session("key")="" or session("key")="ÇëÊäÈë¹Ø¼ü×Ö" then
com_sql="SELECT id,com_id, company_name, country, province, grade, biz_type, main_product FROM pt_company_e where online='1' ORDER BY priority DESC"
end if
if session("key")<>"" and session("key")<>"ÇëÊäÈë¹Ø¼ü×Ö" then
if session("xtype")="x" then
com_sql="SELECT id,com_id, company_name, country, province, grade, biz_type, main_product FROM pt_company_e WHERE company_name LIKE '%"& session("key") &"%' and online='1' OR main_product LIKE '%"& session("key") &"%' and online='1' OR detail_info LIKE '%"& session("key") &"%' and online='1' OR province LIKE '%"& session("key") &"%' and online='1' OR contact LIKE '%"& session("key") &"%' and online='1' OR zip_code LIKE '%"& session("key") &"%' and online='1' OR city LIKE '%"& session("key") &"%' and online='1' ORDER BY priority DESC"
else
com_sql="SELECT id,com_id, company_name, country, province, grade, biz_type, main_product FROM pt_company_e where "& session("xtype") &" like '%"& session("key") &"%' and online='1' ORDER BY priority DESC"
end if
else
end if
session("com_sql")=com_sql
else
if session("com_sql")="" then
session("com_sql")="SELECT id,com_id, company_name, country, province, grade, biz_type, main_product FROM pt_company_e where online='1' ORDER BY priority DESC"
end if
end if
%>
Chinaairtools,Professional E-market for China Air Tools
