public function getDetail($id) { $customer = array('cid', 'esid', 'name', 'broker_code'); $broker_new = array('sid', 'company_name', 'broker_name','phone_number'); $select = $this->select() ->setIntegrityCheck(false) ->from(array('c' => 'customer'),$customer); $select->join(array('b' => 'broker_new'), 'b.broker_code=c.broker_code', $broker_new); $select->where('c.cid =?',$id); $row = $this->fetchRow($select); if($row){ return $row; }else{ return false; } }