execute several queries, batch queries.

[eluser]jorgeakanieves[/eluser]
I have to do several inserts into the same table. I don´t want to get it using a for bucle. I thinks it´s possible to do this in the same transaction.

how could I do?

It´s not valid:

Code:

$query ="INSERT INTO table(field1,field2,field3) VALUES ('16','2','5');INSERT INTO table(field1,field2,field3) VALUES ('16','3','4');INSERT INTO table(field1,field2,field3) VALUES ('16','4','3');INSERT INTO table(field1,field2,field3) VALUES ('16','5','2');INSERT INTO table(field1,field2,field3) VALUES ('16','6','1');"

$query = $this->db->query($sql);
return $query->result();