How to write this query in yii and print it without using foreach loop?

Question

I have written this query in sql and it is working fine, I am getting the exact result which I wanted, but when I write this query in Yii, and if I do not use foreach loop I get this error array to string conversion. Query in sql

SELECT description FROM `comment_business` where review_business_id=72;

Query in Yii

 $results=Yii::app()->db->CreateCommand()  
                                ->select('description')
                                ->from('comment_business b')
                               ->where('b.review_business_id='.$ba->id)
                                ->queryRow();
     echo $results;

I know in sql, I get the description, but here, how can I achieve my results, without using foreach loop ?

I have

ScaisEdge · Accepted Answer · 2015-12-24 14:04:28Z

1

if you get an only row try

echo $result['description'];

if you get more than a row you need index

 echo $result[0]['description'];

answered Dec 24, 2015 at 14:04

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Usman Iqbal Over a year ago

Oh how stupid I am, it was so simple, Thanks Scais sir.

Collectives™ on Stack Overflow

How to write this query in yii and print it without using foreach loop?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related