include_once("include/main.inc.php"); mainHeader(); if ($_REQUEST[next_month]!="") { $this_month=$_REQUEST[next_month]; $this_year=$_REQUEST[next_year]; } else if ($_REQUEST[prev_month]!="") { $this_month=$_REQUEST[prev_month]; $this_year=$_REQUEST[prev_year]; } if ($_REQUEST[event_date]!="") { $event_date=$_REQUEST[event_date]; $sry1=" and ('".$event_date."' between eventDateFrom And eventDateTo)"; }else{ if($_REQUEST[prev_month]!="" || $_REQUEST[next_month]!=''){ $day=($this_month==date("m") && $this_year==date("Y")) ? date("d") : "01"; $month=$this_month; $year=$this_year; }else{ $day=date("d"); $month=date("m"); $year=date("Y"); } $event_date=date("Y-m-d",(mktime(0,0,0,$month,$day,$year))); $sry1=" and ('".$event_date."' between eventDateFrom And eventDateTo)"; } $start=$_REQUEST[start]; $pagesize=$_REQUEST[pagesize]; $start = (intval($start)<0 or $start=="")?0:$start; $pagesize = intval($pagesize)==0?$pagesize=5:$pagesize; $qry1="select * from tbl_events where status='Y' $sry1"; $reccnt = mysql_num_rows(db_query($qry1)); $qry1.=" limit $start, $pagesize"; $qry= db_query($qry1); ?>
|
|||||||||||||||||||||||||||