CODEWITHSUNDEEP
yii
user7282
user7282

Reputation: 5196

Multiple columns in find() in yii

I need to find name and address columns only from database I am usinf the following query

$criteria=new CDbCriteria;
$criteria->select='name';
$criteria->select='address';
$criteria->condition="username=:username";
$criteria->addCondition("active=:active");
$criteria->params=array(':username'=>$this->username,':active'=>1);
$record=User::model()->find($criteria);

But I am geting only 'address'in the output. How can I get both column results? Is there anything similar like addCondition() for specifying wanted columns only for select also ?

Upvotes: 1

Views: 4891

Answers (1)

Rohan
Rohan

Reputation: 3334

Separate your select requirements with commas instead of placing them separately.

$criteria=new CDbCriteria;
$criteria->select='name,address';
$criteria->condition="username=:username";
$criteria->addCondition("active=:active");
$criteria->params=array(':username'=>$this->username,':active'=>1);
$record=User::model()->find($criteria);

Upvotes: 2

Related Questions