<? include("db_connect.php"); //设置当前页显示的数量(这个数量可任意设置) $limit=3; //初始化数据库搜索起始记录 if (empty($start)) $start=0; //设置数据库记录总数 $result=mysql_query("select * from book"); $num_max=mysql_num_rows($result); echo "$num_max"; $result=mysql_query("select * from book order by book_id DESC limit $start,$limit"); $num=mysql_num_rows($result); echo "$num"; echo ""; if (!empty($num)) { for ($i=0;$i<$num;$i++) { $val=mysql_result($result,$i,"book_title"); $val1=mysql_result($result,$i,"book_author"); echo ""; } } echo "

翻页功能
$val	$val1
"; //设置向前翻页的跳转 $prve=$start-$limit; if ($prve>=0) { echo "prve"; } //设置向后翻页的跳转 $next=$start+$limit; if ($next<$num_max) { echo "next"; } echo "

"; ?>