改成这样: <? $db=mysql_connect("localhost","数据库名","密码"); mysql_select_db("数据库名",$db); $result=mysql_query("select * from 表名 ORDER BY 列名1 DESC limit 6",$db); do { printf("%s%s", $myrow["ID"],$myrow["列名1"], $myrow["列名2"]); } while ($myrow=mysql_fetch_array($result));?>
limit可带两个参数:
limit 记录数
limit 起始位置, 记录数
<?
$db=mysql_connect("localhost","数据库名","密码");
mysql_select_db("数据库名",$db);
$result=mysql_query("select * from 表名 ORDER BY 列名1 DESC limit 6",$db);
do
{
printf("%s%s", $myrow["ID"],$myrow["列名1"], $myrow["列名2"]);
}
while ($myrow=mysql_fetch_array($result));?>