Question

为什么加了order by 语句后,出错，去掉order by 后OK $SQL="SELECT * FROM `message` order by id desc"

出现错误：Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\PHPtool\list.php on line 13

只要去掉order by id desc后就没有问题。

Answer 1

select *
from message
order by message.id desc
试试，，你原来的sql语言理论上也是对的，可能是表或表的属性名弄错了吧