Getting next ID before insert

[eluser]Felipe Deitos[/eluser]
Ckirk: I guess this is wrong, example: if your last recorded id is 570 but u got the 571 and 572 deleted the next id would be 573, but in your code it will be 571.

Sotoz: Thats what i am doing i wrote some functions yesterday and make it work really great, take a look:

Code:

function create(){
  
  $info = array(
   'idcategoria' => $this->input->post('ipt_categoria'),
   'codigo' => $this->input->post('ipt_codigo'),
   'nome' => $this->input->post('ipt_nome'),
   'descricao' => $this->input->post('ipt_descricao'),
   'esp_tecnica' => $this->input->post('ipt_esp_tecnica'),
   'ativo' => $this->input->post('ipt_ativo'),
   'destaque' => $this->input->post('ipt_destaque')
  );
  
  
  $query = $this->db->insert('produtos', $info);
  //Could make one if $query
  $insert_id = $this->db->insert_id();
  
  $files = $_FILES;
  $erros = array();
  $imagens = array();
  foreach($files as $field => $file){
   if(!empty($file['name'])){
    $upload = $this->upload_imagem($insert_id, $field); //upload image function
    if(isset($upload['error'])){
     $erros[$field] = $upload['error'];
    }else{
     $imagens[$field] = $upload['imagem'];
    }
   }
  }
  
  if(!empty($erros)){
   foreach($erros as $key => $erro){
   // doing it now, there are 5 images so if the 4 give anything wrong i delete the others and delete the record too.
   }
  }else{
   $this->db->where('id', $insert_id);
   $this->db->update('produtos', $imagens);
  }
}

Thanks for the answers guys, really appreciated!

Cheers!