In the ListningsController.php find(CConfig::get(‘db.prefix’).’regions.id = :id’, array(‘i:id’=>$ listing->region_id)); $ result = Regions::model()->find(CConfig::get(‘db.prefix’).’regions.id = :id’, array(‘i:id’=>$ listing->region_id)); $ region = !empty($ result) ? $ result->getFieldsAsArray() : array(); $ region = !empty($ result) ? $ result->getFieldsAsArray() : array(); $ this->_view->listingLocation = !empty($ region[‘name’]) ? $ region[‘name’] : ”; $ this->_view->listingLocation = !empty($ region[‘name’]) ? $ region[‘name’] :Read more