orderby=Request("orderby")
if Orderby="姓名" then
strsql="select * from tablename order by 姓名"
elseif Orderby="学号" then
strsql="select * from tablename order by 学号"
elseif Orderby="成绩" then
strsql="select * from tablename order by 成绩"
end if
.....你的数据库处理过程
表头:
<td><a href="self.asp?orderby=姓名">姓名</a></td>
<td><a href="self.asp?orderby=学号">学号</a></td>
<td><a href="self.asp?orderby=成绩">成绩</a></td>