I got this function:
private function _loadColumnRights() {
$db = Zend_Registry::get('db');
// Create the select query
$select = $db->select()
->from('account_columns', array(
'accountId'
))
->where('accountId = ?', $this->getId());
// Fetch the data
$row = $db->fetchRow($select);
if($row != null) {
$this->setColumns($row['columns']);
}
else {
$this->setColumns('');
}
}
I search for the accountID = '128'
My table looks like this:
accountId | columns
and at row with accountId = '128'
I got a value like this 'orderdate,ref-corlido,item-no,partid,item-description,quantity-value,unit-of-measurement,acquisition-value-order-line,sales-value-order-line,markup,due-date,status,direct-delivery,out-of-scope,non-compliant,memo,request-document,documents'
If I in PHP manually execute this SQL statement:
SELECT * FROM `account_columns` WHERE `accountId` = '128'
Then I get result..
my Code also goes in to this if:
if($row != null) {
$this->setColumns($row['columns']);
}
But the value of $row['columns'
] is empty.. If I perform a var_dump on my view on this getter then i get empty values
If I change $row['columns']
) to :
$this->setColumns($row['accountId']);
then I get the 128 value.. But I don't get the column values.. How come?