$date_added_from = isset($_REQUEST['date_added_from']) ? utility::setFormatedDate($_REQUEST['date_added_from']) : ""; $date_added_to = isset($_REQUEST['date_added_to']) ? utility::setFormatedDate($_REQUEST['date_added_to']) : ""; if($date_added_from && $date_added_to) { $where .= " AND date_added BETWEEN '$date_added_from 00:00:00' and '$date_added_to 23:59:59' "; $next_page_condition.="&date_added_from=".$_REQUEST['date_added_from']."&date_added_to=".$_REQUEST['date_added_to']." "; }else if($date_added_from){ $where .= " AND date_added >= '$date_added_from' "; $next_page_condition.="&date_added_from=".$_REQUEST['date_added_from']; }else if($date_added_to){ $where .= " AND date_added <= '$date_added_to' "; $next_page_condition.="&date_added_to=".$_REQUEST['date_added_to']; }