How to do this query?

[eluser]TheFuzzy0ne[/eluser]
I'd try doing it like this:

Code:

$res = $this->db->get_where('table', 'id = MAX(id)');