01.<?
02.include("../Connect/conn.php");
03.include("../calendar.php");
04.include("../User_Function/all_function.php");
05.include("../User_Function/function.php");
06.$date1=$_POST['DATE'];
07.$date2=$_POST['exampleII'];
08.$paystatus=$_POST['paystatus'];
09.if($date1!='' ||$date2!='' ){
10.
11.$strSQL = "SELECT * FROM tb_order Where date between '$date1' and '$date2' and paystatus=$paystatus order by date DESC";
12.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
13.$Num_Rows = mysql_num_rows($objQuery);
14.
15.
16.
17.$num=1;
18.
19.$Per_Page =15;
20.
21.
22.
23.$Page = $_GET["Page"];
24.if(!$_GET["Page"])
25.{
26. $Page=1;
27.}
28.
29.$Prev_Page = $Page-1;
30.$Next_Page = $Page+1;
31.
32.$Page_Start = (($Per_Page*$Page)-$Per_Page);
33.if($Num_Rows<=$Per_Page)
34.{
35. $Num_Pages =1;
36.}
37.else if(($Num_Rows % $Per_Page)==0)
38.{
39. $Num_Pages =($Num_Rows/$Per_Page) ;
40.}
41.else
42.{
43. $Num_Pages =($Num_Rows/$Per_Page)+1;
44. $Num_Pages = (int)$Num_Pages;
45.}
46.$Page_End = $Per_Page * $Page;
47.IF ($Page_End > $Num_Rows)
48.{
49. $Page_End = $Num_Rows;
50.}
51.
52.?>
