Database trouble - Error Number: 1096

[eluser]Armchair Samurai[/eluser]
I don't think this is a bug - AFAIK count_all_results() does not use select(), which is probably causing the error. Using count_all_results() creates

Code:

SELECT COUNT(*) AS numrows

meaning you can also get rid of the order_by() and limit() without affecting the outcome, so you'd end up with:

Code:

$this->db->from(’tbl_gallery’);
$this->db->join("tbl_users", “gallery_user = usr_id");
$this->db->join("tbl_gallery_albums", “gallery_album = album_id");
$this->db->where(’gallery_user’, $userid);
$this->db->where(’gallery_album’, $gallery);
$total = $this->db->count_all_results();