28/02/2012 8:12pm

PHP | Problem - SQL


$filter = "Price < " . $maxprice . " AND Price > " . $minprice . " AND isActive = '" . $isActive . "'" . " AND AmenityID = '" . $AmenityID . "'";

Debug::show($filter);
$sort = 'Created ASC';
$join = 'LEFT JOIN `Apartment_Amenities` ON `ApartmentID` = `Apartment`.ID';
$limit = $_REQUEST['start'].",10";


return DataObject::get('Apartment', $filter, $sort, $join, $limit);


Post Comment