php怎么查询出重名用户月总积分 本帖最后由 chenxuezhi1986 于 2011-02-22 01:05:39 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $sql = "select *,sum(myscore) as allscore from talbe group by id order by allscore desc"; select username,SUM(myscore) as score from tabletest group by username order by score desc 笔误 更正:$sql = "select *,sum(myscore) as allscore from talbe group by username order by allscore desc"; SELECT username,sum(myscore) as score FROM `test` GROUP BY username ORDER BY score DESC select 用户名,sum(积分)from xxxxgroup by 用户名order by 2 desc; 让PHP中Cookie及时生效 无需刷新 php中的proc_open+fwrite应用问题 请教php 一下下载多个zip文件的方法,麻烦各位指点啊! call_user_func_array这个函数 apache rewrite多域名为啥不行呢?[win2003server下] 手机网站做上传图片功能,点击选择图片后文本框是空的。。。。 如何获取下拉列表选定的值!急用!! 关于php如何入门? 关于input type='image'的问题 什么是动态网页?怎样解释? php定时每天11:30在自动执行php程序代码? 变成伪静态后,是不是还要修改每个链接?
select username,SUM(myscore) as score from tabletest group by username order by score desc
$sql = "select *,sum(myscore) as allscore from talbe group by username order by allscore desc";
SELECT username,sum(myscore) as score FROM `test` GROUP BY username ORDER BY score DESC
from xxxx
group by 用户名
order by 2 desc;