Database trouble - Error Number: 1096

[eluser]coldKingdom[/eluser]
Hi, and thanks!

But i still get the same error message, any other ideas?

It doesn't matter where i put $this->db->count_all_results(); on the site, it still breaks the sql-statement by saying "no tables used".

It works if i put it after $query = $this->db->get(); but then it came up with 1 when did a echo on it, when i echo the $this->db->count_all_results(); when on it's right place the right number comes up, so it's just the error message in the way