在sql语句中 $ 是你要排序的字段名sql2="select top 10 * from venshop_article where a_sort="&rs("sort_id")&" order by $ desc"例如:排序字段名IDsql2="select top 10 * from venshop_article where a_sort="&rs("sort_id")&" order by ID desc"