我的一個php顯示記錄的 現在未加分頁功能! 不指定

Else , 2007/07/04 10:56 , 代码片段,演示也有 , Comments(0) , Reads(6571) , Via Original
显示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;
}
Tags:
Add a comment

Nickname

Site URI

Email

Enable HTML Enable UBB Enable Emots Hidden Remember [Login] [Register]