mysql 排序之后添加 序列号 以及查询

select * from (select id,name,score,ipone,time,(@i:=@i+1) as i from `user`,(select (@i:=0)) b order by score desc time asc) c where ipone=%d; ",array($where['ipone']));

select (@i:=@i+1) as i,user. * from user,((select @i:=0) as it) ORDER BY score  DESC , time asc 



//防止mysql乱码
set names utf8