[eluser]Phil Sturgeon[/eluser]
This gives you an error? That's not because you are missing a ; at the after the query string is it?
Anyway to answer the question, if you are only trying to only do multiple INSERT's, then use the following structure for your queries.
Code:
$query ="INSERT INTO table(field1,field2,field3) VALUES
('16','2','5'),
('16','3','4'),
('16','4','3'),
('16','5','2'),
('16','6','1');";
$query = $this->db->query($sql);
return $query->result();