简单分页思路
<?php$sql = 'select * from tablename ';$res = mysql_query($sql);$num = mysql_fetch_row($res); //返回总的行数if(empty($_GET['page'])){$page = 0;}else{$page = $_GET['page'];if($page < 0){$page = 0;}if($page >= ceil($num/10)) //ceil() -> 返回 向上舍入为最接近的整数{$page = ceil($num/10) - 1;}}mysql_query('select * from tablename order by id limit '.$page.',10');?><a href="page.php?page=0">首页</a><a href="page.php?page=<?=$page-1?>">上一页</a><a href="page.php?page=<?=$page+1?>">下一页</a><a href="page.php?page=<?=ceil($num/10)-1?>">尾页</a>?