CODEWITHSUNDEEP
yii
SnIpY
SnIpY

Reputation: 662

Yii Get oldest object from db - findByAttributes

Using a FindByAttributes query I would like to get the oldest element out of my database.

My Code:

$oMemberLocked = MembersLocked::model()->findByAttributes(array(
        'lockedid' => $this->id,
        'request' => 2,
    ));

The object MembersLocked has a attribute 'date'.

How can I get the element with the largest date?

Upvotes: 1

Views: 2519

Answers (1)

Puigcerber
Puigcerber

Reputation: 10114

You can order the query by ascending date.

$criteria = new CDbCriteria;
$criteria->order = 'date ASC';
$oMemberLocked = MembersLocked::model()->findByAttributes(array(
    'lockedid' => $this->id,
    'request' => 2,
), $criteria);

Upvotes: 4

Related Questions