对user表中的用户按地区列出注册的顺序
SELECT A.*,@rank:=@rank+1 as pm FROM (SELECT qid,area1 from user order by area1,createtime DESC) A,(SELECT @rank:=0) B
对user表中的用户按地区列出注册的顺序
SELECT A.*,@rank:=@rank+1 as pm FROM (SELECT qid,area1 from user order by area1,createtime DESC) A,(SELECT @rank:=0) B