php+mysqlÖУ¬ÅÅÐòÈ¡Ãû´Î

fenshu±íÖеÄ×Ö¶ÎΪ£ºid,user,fs
7Ìõ¼Ç¼ÈçÏ£º
0¡¡ÕÅÈý¡¡10
1¡¡ÀîËÄ¡¡20
2¡¡ÍõÎå¡¡60
3¡¡Ð¡¶þ¡¡30
4¡¡ºÇºÇ¡¡40
5¡¡Ð¡»¨¡¡80
6¡¡Ð¡°×¡¡40
°´fs½µÐòÅÅÐòºóµÃµ½£º
5¡¡Ð¡»¨¡¡80
2¡¡ÍõÎå¡¡60
4¡¡ºÇºÇ¡¡40
6¡¡Ð¡°×¡¡40
3¡¡Ð¡¶þ¡¡30
1¡¡ÀîËÄ¡¡20
0¡¡ÕÅÈý¡¡10
ÈçºÎȡΪfsΪ40µÄ¼Ç¼½µÐòÅÅÁдÎÐò¼´3»ò4

---

SQL code:
select b.*
(select a.*,(select count(*)+1 from fenshu where fs>a.fs) as row_num from fenshu a) b
order by b.row_num desc;

---

ÒýÓÃ

SQL codeselect b.*
(select a.*,(selectcount(*)+1from fenshuwhere fs>a.fs)as row_numfrom fenshu a) borderby b.row_numdesc;

ÀïÃæµÄaºÍbÖ¸µÄÊÇʲô£¿ÈçºÎÊä³öÃû´Î£¿

---

a,bÊDZíµÄ±ðÃû£¬×Ö¶Îrow_num¾ÍÊÇÃû´ÎÁË

---

Èý¸öselect·Ö¿ªÔõôд£¿

---

SELECT a.id,a.user,a.fs,count(b.id) from t1 a left join t1 b on (a.fs <b.fs) or (a.fs=b.fs and a.id>=b.id)
group by  a.id,a.user,a.fs
order by a.fs desc

---

MySQLÖеÄROWNUMµÄʵÏÖ
http://blog.csdn.net/ACMAIN_CHM/archive/2009/04/20/4095531.aspx

---

ʵÏÖÁË£¬Ð»Ð»¸÷λ