Yii find the condition> =

Question

I need to find a line where sum> = 250

I do the following:

$criteria = new CDbCriteria;  
$criteria->condition ='summ >= 250';
$winnerBid = Bids::model()->find($criteria);

But I do not get any results. How to implement?

Answer 1

I do not have Yii. Have you tried this:

$criteria = new CDbCriteria;  
$criteria->addCondition('summ >= 250');
$winnerBid = Bids::model()->find($criteria);

This should work if summ- this is a correctly displayed column.

Answer 2

$winnerBid = Bids::model()->find('summ >= 250');
if ($winnerBid===null) {
    throw new CHttpException(400,'There is no record in your database with summ>=250.');
}

Answer 3

, -

$winnerBid = Bids::model()->find(array('condition'=>"summ >= 250"));

Answer 4

$criteria = new CDbCriteria;  
$criteria->condition ='summ >= 250';
$winnerBid = Bids::model()->findAll($criteria);

>=, FindAll() .

Answer 5

: http://yiitutorials.net/easy/yii-getting-info-from-the-database