一个PHP+MSSQL分页的例子
<?require "config.php(做为现在的主流开发语言)";
dl("extensions/php(做为现在的主流开发语言)_mssql(WINDOWS平台上强大的数据库平台)70.dll");
if (!isset($page)) { $page=1; }
if ($page<=0) { $page=1; }
$db=mssql(WINDOWS平台上强大的数据库平台)_connect($local,$user,$pass);
mssql(WINDOWS平台上强大的数据库平台)_select_db($name,$db);
$query=mssql(WINDOWS平台上强大的数据库平台)_query("select count(*) as date from news",$db);
$query=mssql(WINDOWS平台上强大的数据库平台)_fetch_array($query);
$pages=ceil($query[0]/$userperpage);
if ($page>$pages) { $page=$pages;}
if ($query[0]<$userperpage) { $userperpage=$query[0]; }
$dangqian=($page-1)*$userperpage;
echo "<title>News</title>";
echo "<style type=text/css> ";
echo "<!-- ";
echo "A{text-decoration:none} ";
echo "A:hover {color:blue;; text-decoration: underline} ";
echo "td { font-size: 9pt} ";
echo "--></style> ";
echo "<div align=center><center> ";
echo "<table border=0 width=100% cellspacing=0 cellpadding=0 height=19 ";
echo "<tr>";
echo " <td width=52% colspan=5><img src="/edu/UploadPic/2008-2/2008215181316912.gif" width=100%></td></tr> ";
echo "<tr>";
echo " <td width=52% height=19 valign=bottom bgcolor=#B5C6B0><p align=center><font ";
echo " color=#408080>新闻标题</font></td> ";
echo " <td width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0><font ";
echo " color=#408080>发表日期</font></td> ";
echo " <td width=19% height=19 valign=bottom align=center bgcolor=#B5C6B0><font ";
echo " color=#408080>发表部门</font></td> ";
echo " <td width=7% height=19 valign=bottom align=center bgcolor=#B5C6B0><font ";
echo " color=#408080>阅读</font></td> ";
echo " <td width=8% height=19 valign=bottom align=center bgcolor=#B5C6B0><font ";
echo " color=#408080>图像</font></td> ";
echo " </tr> ";
echo "</table> ";
echo "</center></div> ";
echo "<div align=center><center> ";
echo "<table border=0 width=100% cellspacing=0 cellpadding=0 height=19> ";
$db=mssql(WINDOWS平台上强大的数据库平台)_connect($local,$user,$pass);
mssql(WINDOWS平台上强大的数据库平台)_select_db($name,$db);
$query=mssql(WINDOWS平台上强大的数据库平台)_query("select * from news order by date desc",$db);
$roro=mssql(WINDOWS平台上强大的数据库平台)_num_rows($query);
if ($roro==0) {
echo "<br><br><p align="center"><font color="#FF0000" size="2"><marquee behavior="alternate" border="0" width="300" height="16" scrolldelay="70">目前数据库中无任何记录!</marquee></font></p>";
补充:Web开发 , php ,