Getting next ID before insert

[eluser]Ckirk[/eluser]
how about:

Code:

// users table for example
$query = $this->db->query('SELECT id FROM users ORDER BY id DESC LIMIT 1');
if ($query->num_rows() > 0)
{
  $user = $query->result();
  $next_id = $user[0]->id + 1;
}