Search Coupon Code: View All Admin: View Coupons 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 fetchNextObject($sql)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?> Record Found. S No. ID Campaign Valid For Email Coupon Code Discount No. of Uses Minimum Purchase Valid Till Status Action . id); ?> hero=='0' && $line->ref_user_id!=''){ echo "Be A Hero"; } if($line->hero=='' && $line->ref_user_id!='' && $line->spin==''){ echo "Refer A Friend"; } if($line->spin=='1' && $line->ref_user_id!=''){ echo "Spin the Wheel Game"; }?> valid_for); ?> User(s) to_email); ?> coupon_code); ?> discount_type=='Direct') { echo 'Rs.'; } echo stripslashes($line->discount); ?> discount_type=='Percent') { echo '%'; }?> valid_time=='') { echo 'Unlimited'; }?> valid_time!='') { echo $line->valid_time; echo ' Times'; }?> Rs. minimum_purchase); ?> expire_date!='0000-00-00'){echo date('d M Y',strtotime($line->expire_date));} ?> status==1){?>