searching from date to date

$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'];
}

Leave a Reply

Your email address will not be published. Required fields are marked *