Using varialbes with more than one sql operation.

[eluser]manilodisan[/eluser]
I don't think it will work. I suggest you to execute the query inside the loop:

Code:

for ($i = 1; $i <= 10; $i++ )
{
        $id = $this->input->post('field'.$i);
        $this->db->query("DELETE FROM table WHERE id =".$this->db->escape($id)."");
}