How can you run an mysqli query?

[eluser]WanWizard[/eluser]
CI doesn't support multiple SQL statements in one go.

Use

Code:

$sql = "SELECT * FROM c WHERE 1";
$query = $this->db->query($sql);

$sql = "DROP TABLE IF EXISTS c;";
$query = $this->db->query($sql);