关于mysql字段排序问题,急

[Hovers]

表名 compositor
字段id,username,successes,command,clay,favor
按照successes字段进行表排序
得出结果应该是从大到小排列出来的临时表XXX,并在临时表第一个列增加新的ID序列号

[mschen]

/* 如下所示 */
mysql>create table a(name varchar(10));

mysql>insert a select 'a';
mysql>insert a select 'b';
mysql>insert a select 'c';

mysql>create temporary table b(id int not null auto_increment primary key,name varchar(10))
select name from a order by name desc;

mysql>select * from b;

结果如下:

id name
1 c
2 b
3 a

[Hovers]

$dbh = mysql_connect("$dbhost","$dbuser","$dbpw");
mysql_select_db("$dbname");
mysql_query("set names 'gb2312'");
$sql="SELECT id,username,successes,command,clay,favor FROM compositor";
$sql="select cnt = (select count(successes)+1 from compositor where successes< a.successes),id,username,successes,command,clay,favor from compositor a order by successes desc";

$bullentin = mysql_query($sql, $dbh);
?>


兄弟以上写法运行失败啊?提示SQL语句有问题

[小辉]

呵呵 这样就可以

select cnt = (select count(successes)+1 from compositor where successes< a.successes) ,
id,username,successes,command,clay,favor
from compositor a

但是不知道你版本行不行
兄弟试试看
不行我重新给你写哈

[小辉]

不好意思
少了个排序

select cnt = (select count(successes)+1 from compositor where successes< a.successes) ,
id,username,successes,command,clay,favor
from compositor a
order by successes desc