Question

PHP文章按倒序显示问题！

$sql="select * from news where classid=".$id;
$result=mysql_query($sql);

while($rs=mysql_fetch_object($result))
{
echo $rs->title ;
}

我想让显示的文章按ID的递减排列，正常情况是用order by id desc
但是不好用，希望有明白的不吝赐教，最好能留个QQ，长期有问题请教……

Answer 1

就是这样的啊，怎么会不行

$sql="select * from news where classid=".$id." order by id desc;

Answer 2

$sql="select * from news where classid=".$id." order by id desc
";
$result=mysql_query($sql);

while($rs=mysql_fetch_array($result))
{
echo $rs["title"] ;
}
为什么要用mysql_fetch_object？

Answer 3

$sql="select * from news where classid=".$id." order id desc";
$result=mysql_query($sql);

while($rs=mysql_fetch_object($result))
{
echo $rs->title ;
}