我的一個php顯示記錄的 現在未加分頁功能!
显示mssql的记录
function listnews($newscount){
$query = "select top $newscount id,title,[time] from sitenews order by uptop asc,id desc ";
//if (!isset($page)) { $page=1; }
//if ($page<=0) { $page=1; }
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
while($row = mssql_fetch_array($result))
{
$news_title=$row["title"];
$news_id=$row["id"];
$news_time=cnSubStr($row["time"],10); //format date time 0000-00-00 00:00
$news_list=$news_list. "<a href=\"show.php?id=" . $row["id"] ."\" target=\"_bleak\" title=\"$news_title\">$news_title </a>$news_time<br />";
}
//$news_list=$news_list."<hr /><div style=\"text-align:center;\">News $numRows,at present 1/1 Page <a href=?page=1>First Page</a> - previous - Next - Last Page </div>";
mssql_free_result($result);
echo $news_list;
}
$query = "select top $newscount id,title,[time] from sitenews order by uptop asc,id desc ";
//if (!isset($page)) { $page=1; }
//if ($page<=0) { $page=1; }
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
while($row = mssql_fetch_array($result))
{
$news_title=$row["title"];
$news_id=$row["id"];
$news_time=cnSubStr($row["time"],10); //format date time 0000-00-00 00:00
$news_list=$news_list. "<a href=\"show.php?id=" . $row["id"] ."\" target=\"_bleak\" title=\"$news_title\">$news_title </a>$news_time<br />";
}
//$news_list=$news_list."<hr /><div style=\"text-align:center;\">News $numRows,at present 1/1 Page <a href=?page=1>First Page</a> - previous - Next - Last Page </div>";
mssql_free_result($result);
echo $news_list;
}
一个asp函数和一个php函数 相同的功能
一个登入的代码php
