Get last item in list

Hi, In my database table I would like to be able to get the last row that was created.

Have I got this model function correct. Just unsure of my self not sure if there is another easier way?

PHP Code:

public function getpostinfofordeleteupdate()
{
    $query = $this->db->order_by('datecreated', 'desc')
              ->limit(1)
              ->get($this->db->dbprefix . 'posts');

    return $query->row_array();
} 


Thanks for your time.

There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!

Sorting as you are doing here is the only way I can think of todo that.

Sorting as you are doing here is the only way I can think of todo that.

Thank you. It works fine just was unsure if any other way using DB stuff in model.

There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!

If you only want the ID of the record you could use a select max to get it