Problem by select from db when there is a space followed by a comma in where clause

[eluser]johnpeace[/eluser]
It doesn't look like you're using

Code:

$this->db->select()

correctly.

It looks like you're trying to pass an entire query to that method, when it only expects the fields you're trying to get data from in your query.

Your query could be probably be rewritten as an active record statement. If it can't, and you need to write a whole query to run you should try this:

Code:

$this->db->query('YOUR QUERY HERE');