1. 

   xledoo New Member

   Joined:

   Nov 15, 2005

   Messages:

   109

   Likes Received:

   0

   php+mssql 操作
   数据库中有一个member表，用来记录用户 uid , name , exp 等信息~
   我要以 exp 的大小为序来显示用户的 name 信息~从大到小显示！
   
   SELECT name,exp FROM member order by exp
   可这样显示的是 exp 从小到大啊？怎么才能把它反过来排列呢？

    

   #1 xledoo, Jun 7, 2006
2. 

   小叶 New Member

   Joined:

   Sep 4, 2005

   Messages:

   17,941

   Likes Received:

   33

   SELECT name,exp FROM member order by exp asc

    

   #2 小叶, Jun 7, 2006
3. 

   xledoo New Member

   Joined:

   Nov 15, 2005

   Messages:

   109

   Likes Received:

   0

   谢谢~小叶

    

   #3 xledoo, Jun 7, 2006

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in