Yii Database

hi , i am not able to get last 10 element in yii , using findby sql

down vote favorite

public function getGet($nid)

   {


      $sensor = $this->findBySql("select * from tbl_sensor where stype=4 and nid=$nid order by timestamp desc limit 10;");





    if ($sensor == NULL)


    return "NULL";


    return $sensor->sdata;


   }

Use findAllBySql instead of findBySql.