开发者

Yii find condition >=

开发者 https://www.devze.com 2023-02-18 11:26 出处:网络
I need to find row where summ>=250 I am doing following: $criteria = new CDbCriteria; $criteria->condition =\'summ >= 250\';

I need to find row where summ>=250

I am doing following:

$criteria = new CDbCriteria;  
$criteria->condition ='summ >= 250';
$winnerBid = Bids::model()->find($c开发者_StackOverflow社区riteria);

But I am getting no results. How to implement?


I dont have Yii at hand. Have you tried this:

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

This should work, if summ is a column mapped correctly.


It will be usefull, try this -

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


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


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

Since you're using >= you should use FindAll() This should solve your problem.


This might also help: http://yiitutorials.net/easy/yii-getting-info-from-the-database

0

精彩评论

暂无评论...
验证码 换一张
取 消