[solved]MYSQL ERROR 1096 - NO TABLES USED - CODEIGNITER

[eluser]Aken[/eluser]
Bingo. $this->db->query() is NOT an active record function, and is meant to be used by itself. $this->db->get() is part of active record, and can be used in conjunction with select(), where(), limit(), etc.

I'd recommend using the normal query() method for most queries, unless you intend on distributing your application for use with more than one type of database. Active record can be handy, but it has its limitations and does slow down your application a minimal amount (important for high traffic sites).