mysql_num_rows ?

jack1 · July 21, 2009, 6:29pm

Hello,

How can I get the number of result returned by a find (or findByAttributes) method ?

Thank you,

Best Regards,

Jack

qwerty · July 21, 2009, 7:01pm

Hi,

you can use Model::model()->count($condition).

See count() and countBySql() methods from CActiveRecord.

jack1 · July 21, 2009, 8:22pm

Thank you, so we have to call the sql statement twice ?

qwerty · July 21, 2009, 8:43pm

Yes, look at actionList generated by CRUD, there is example how count() is used to pagination.

qiang · July 21, 2009, 11:38pm

If you are calling find() or findByAttributes(), then at most there is one record returned. If you are calling findAll(), then why don’t use count($results)?