<?php
$str="SELECT id,date,name,address,pass FROM company WHERE active='1' ORDER BY date asc LIMIT 20 ";
$res=mysql_query($str) or die(mysql_error());
while($row=mysql_fetch_array($res)):
$id=$row[id];
$name=$row[name];
$address=$row[address];
?>
$str="SELECT id,date,name,address,pass FROM company WHERE active='1' ORDER BY date asc LIMIT 20 ";
$res=mysql_query($str) or die(mysql_error());
while($row=mysql_fetch_array($res)):
$id=$row[id];
$name=$row[name];
$address=$row[address];
?>
还有一种方法,就是先把符合要求的总记录数找出来,然后在limit后台写 $total-20,20
才疏学浅,只想出来这两种方法,抱歉.
ORDER BY date desc 改成 ORDER BY date asc或按你的id取也可以.