include("DB/connectDB.php") ?>
$menu = "news";
$page_size = 6;
$Sql = "select count(nd_id) as total_count from news_data";
$result = mysql_query($Sql);
$dbarray = mysql_fetch_array($result);
$total_count = $dbarray['total_count'];
$total_pages = intval($total_count/$page_size);
if ($total_count>$total_pages*$page_size){
$total_pages++;
}
if ($total_pages<=0) $total_pages=1;
$page = 0;
if (!empty($_REQUEST['page'])){
$page = $_REQUEST['page']+0;
}
if ($page>$total_pages) $page=$total_pages;
if ($page<=0) $page=1;
$Sql = " select * from news_data ";
$Sql.= " order by nd_order asc limit ".(($page - 1) * $page_size).",$page_size";
$result = mysql_query($Sql);
$cnt=0;
while($dbarray=mysql_fetch_array($result)) {
$cnt++;
$data[$cnt][1] = $dbarray['nd_id'];
$data[$cnt][2] = $dbarray['nd_adddate'];
$data[$cnt][3] = $dbarray['nd_title'];
$data[$cnt][4] = $dbarray['nd_content'];
}
?>
2010第11屆金手指網路獎
require_once('head.html');
?>
require_once('footer.html');
?>