PHP | Problem -
public function findRealestateListing(){
$result = DataObject::get("RealestatePage","RealestateStyleID = '" . $_GET['value'] . "' AND ParentID = '" . $this->ID . "'");
$result2 = $result->groupBy('RealestateBuilderID');
$RealestateBuilder= new DataObjectSet();
foreach($result2 as $result) {
$builder_id = $result->column('RealestateBuilderID');
$arr['Builder'] = $result;
$BuilderInfo = DataObject::get("RealestateBuilder","ID = '".$builder_id[0]."'");
$arr['Builder']->push($BuilderInfo);
$RealestateBuilder->push($arr);
}
Debug::show($RealestateBuilder);exit;
}
16/05/2012 2:10am
PHP | Solution - Anonymous
public function findRealestateListing(){
if (isset($_GET['category']) && isset($_GET['value']) && is_numeric($_GET['value'])) {
switch ($_GET['category']) {
case 'style': {
$result = DataObject::get("RealestatePage","RealestateStyleID = '" . $_GET['value'] . "' AND ParentID = '" . $this->ID . "'");
$result2 = $result->groupBy('RealestateBuilderID');
$RealestateBuilder= new DataObjectSet();
foreach($result2 as $result) {
$builder_id = $result->column('RealestateBuilderID');
$arr['Builder'] = $result;
$BuilderInfo = DataObject::get("RealestateBuilder","ID = '".$builder_id[0]."'");
$arr['Builder']->push($BuilderInfo);
$RealestateBuilder->push($arr);
}
return $RealestateBuilder;
break;
}
}
}
This is the full code