一个PHP+MSSQL分页的例子_PHP

require "config.php";dl("extensions/php_mssql70.dll");if (!isset($page)) { $page=1; }if ($page$db=mssql_connect($local,$user,$pass);mssql_select_db($name,$db);$query=mssql_query("select count(*) as date from news",$db);$query=mssql_fetch_array($query);$pages=ceil($query[0]/$userperpage);if ($page>$pages) { $page=$pages;}if ($query[0]$dangqian=($page-1)*$userperpage;echo "News";echo "\n";echo "\n";echo "echo "";echo "\n";echo "";echo "echo "    color=#408080>新闻标题\n";echo "echo "    color=#408080>发表日期\n";echo "echo "    color=#408080>发表部门\n";echo "echo "    color=#408080>阅读\n";echo "echo "    color=#408080>图像\n";echo "\n";echo "\n";echo "\n";echo "\n";echo "\n";$db=mssql_connect($local,$user,$pass);mssql_select_db($name,$db);$query=mssql_query("select * from news order by date desc",$db);$roro=mssql_num_rows($query);if ($roro==0) {echo "目前数据库中无任何记录！";exit;}mssql_data_seek($query,$dangqian);$i=0;while ($arr=mssql_fetch_array($query)) {if ($i>=$userperpage) { break;}echo "\n";echo "$arr[title]\n";$datee=date("Y-m-d",$arr[date]);echo "$datee\n";echo "$arr[type]\n";echo "$arr[click]\n";echo "\n";$arr[photo]=trim($arr[photo]);if (($arr[photo]"") || (file_exists($arr[photo]))) {echo "";}else { echo " "; }echo "\n";echo "\n";$i++;}  //whileecho "\n";echo "\n";echo "\n";echo "\n";if ($page1) {echo "首页\n";}if ($page>1) {$upage=$page-1;echo "上一页\n";}for($y=1;$y echo "$y\n";}if ($page$npage=$page+1;echo "下一页\n";}if ($page$pages)  {echo "尾页\n";}echo "\n";echo "\n";echo "\n";echo "\n";?>