【www.gdgbn.com--Action】
function newlista($action){
$sql ="Select * from gx_news ";
if( $action=="today" ){ $sql.=" where datediff(new_time,".date("Y-m-d").")<=0"; }
$result =mysql_query($sql) or die("fail1".mysql_error());
$rs =mysql_fetch_array($result);
$rdcount =mysql_num_rows($result);
if($rdcount){
$pagesize =15;
$pagecount=($rdcount % $pagesize)?(int)($rdcount / $pagesize)+1:$rdcount/$pagesize;//统计总页面
$page =isset($_GET["page"])?$_GET["page"]:1;//取得当前页面
$start =($page>=1 && $page<=$pagecount)?$start=$pagesize*($page-1):$start=1;//取得超始记录
$start =$start;
$sql =$sql." order by id desc limit $start,$pagesize";
$bg =1;
//$resulte =mysql_query($sql) or die("fail".mysql_error());
$result =mysql_query($sql) or die(mysql_error());
while($rs =mysql_fetch_array($result) ){
if( $bg % 2 !=0){
$style="class=color";
}else{
$style="";
}
echo "
$bg++;
}
echo "";
echo "".pagelist($page,$pagecount,$rdcount,"?page=",$pagesize)."";
}else{
echo "暂时没有信息!";
}
}
本人原创转载注明www.111cn.net/phper/php.html