$sql=select * from my_note where note_url='4';
$result=mysql_query($sql) or die('error'.mysql_error());
$allrecord=mysql_num_rows($result);
$page=isset($_get['page'])?$_get['page']:1;
$pagesize=10;
$pagecount=($allrecord % $pagesize)?(int)($allrecord / $pagesize) +1:$allrecord / $pagesize;
$page=($page>$pagecount || $page $start=$pagesize*($page-1);
$sqllist=select * from my_note where note_url='4' order by id desc limit $start,$pagesize ;
$resulte=mysql_query($sqllist) or die('error '.mysql_error());
$num=mysql_num_rows($resulte);
if($num){
while($rs=mysql_fetch_object($resulte)){
if($rs->note_url=='1'){
echo(note_content.%22 class=note target=_blank>.$rs->note_title. [.$rs->note_date.] n);
}else{
echo(id.%22 class=note target=_blank>.$rs->note_title. [.$rs->note_date.]n);
}
}
echo( 共.$pagecount.页 每页.$pagesize.条记录 共.$allrecord.个作品
);
for($i=$pagecount;$i>=1;$i--){
echo(.($i).
);
}
echo(
);
}else{
echo('no infomation');
}
}