How To Get Maximum Id From Mysql Table?

Yii 1.1 General Discussion
1

Hii all,

    i have one TextField inwhich i want to show maximum value from table tobe displayed in textFiled at the time of form load.
2

HI you can write simple sql query…




select MAX(id) from table_name


$criteria = new CDbCriteria();

$criteria->select = max(id),


$r = Model_Name_of_your_table::model()->find($criteria);

echo $r->id;

try it