Search Coupon Code: Genreated From Date: Genreated To Date: View All Admin: View Coupon Report ='".$_REQUEST['search_from_date']."' and generate_date<='".$_REQUEST['search_to_date']."' "; } $start=0; if(isset($_GET['start'])) $start=$_GET['start']; $pagesize=50; if(isset($_GET['pagesize'])) $pagesize=$_GET['pagesize']; $order_by='id'; if(isset($_GET['order_by'])) $order_by=$_GET['order_by']; $order_by2='desc'; if(isset($_GET['order_by2'])) $order_by2=$_GET['order_by2']; $sql=$obj->Query("select * from $tbl_coupon where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("select * from $tbl_coupon where 1=1 $where order by $order_by $order_by2",$debug=-1); $reccnt=$obj->numRows($sql2); if($reccnt==0) { ?> No Record Records Found. fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?> S No. Coupon Code Valid For Particular User's Email Discount Minimum Purchase Valid Till Number of Uses Number of Applied . coupon_code); ?> valid_for); ?> User(s) to_email); ?> discount_type=='Direct') { echo 'Rs.'; } echo stripslashes($line->discount); ?> discount_type=='Percent') { echo '%'; }?> Rs. minimum_purchase); ?> expire_date!='0000-00-00'){echo date('d M Y',strtotime($line->expire_date));} ?> valid_time; ?> query("select count(*) as cs from $tbl_order where coupon_code='".$line->coupon_code."'"); $rsCoup=$obj->fetchNextObject($ordArr); echo $rsCoup->cs; ?>