/* 如下所示 */
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
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
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
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语句有问题