Question

求MYSQL输出语句问题

我要输出最新新闻,,怎么才能输出最新的10条新闻?
<?php
$sql="select * from news order by news_id desc";
$result=mysql_query($sql,$connect);
while($row=mysql_fetch_array($result)){

echo "<a class=a1 href=\"news_show.php?news_id=".$row["news_id"]."\">".$row["news_title"]."</a><br />";
}
?>

Answer 1

$sql="select * from news order by news_id desc limit 0,10";