Ec (2); $ SQL & quot; select * frommy_notewherenote_url4 & quot; & nbsp; $ resultmysql_query ($ SQL) ordie (Error. mysql_error (); & nbsp; $ allrecordmysql_num_rows ($ result); & nbsp; $ pageisset ($ _ GET [script ec (2); script
$ 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 <1 )? $ Page = 1: $ 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. "'class = note target = '_ blank'>". $ rs-> note_title. "[". $ rs-> note_date. "]N ");
} Else {
Echo ("
Id. "'class = note target = '_ blank'>". $ rs-> note_title. "[". $ rs-> note_date. "]N ");
}
}
Echo ("
Total ". $ pagecount." Page per page ". $ pagesize." total records ". $ allrecord." entries
");
For ($ I = $ pagecount; $ I >=1; $ I --){
Echo ("
". ($ I )."
");
}
Echo ("
");
} Else {
Echo ('no Infomation ');
}
}