Multiple INSERT INTO in one $this->db->query

[eluser]Randy Casburn[/eluser]
Assuming you are using the MySQL driver, eventually, this is the command that is run by CI:

Code:

return @mysql_query($sql, $this->conn_id);

This implies, then, that your SQL statements (INSERT or otherwise) must be treated as standalone statements and cannot be compounded as you've attempted to do.

Hope this has been helpful,

Randy