Search Notification: View All Admin: View Notifications Query("select n.* ,nt.name from tbl_notifications n join tbl_notification_type nt on n.notification_type=nt.id where 1=1 $where order by $order_by $order_by2 limit $start, $pagesize"); $sql2=$obj->query("select n.* ,nt.name from tbl_notifications n join tbl_notification_type nt on n.notification_type=nt.id $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 Notification Valid For Email Coupon Code Discount No. of Uses Minimum Purchase Valid Till Status Action . id); ?> name; ?> 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){?>