CodeIgniter - numbers in sql query are masked with ``
- by Checkson
Hello,
i'm using CodeIgniter for developing a community board. As I'm using nested sets to get a nested forum hierarchy, I have to run a lot of queries such as:
SELECT `id` FROM `forums` WHERE 1 BETWEEN `lft` AND `rgt`
My problem: CodeIgniter is replacing the "1" by "`1`" because the "1" is recognized as a column name. Of course, the query does not work any more.
Is there a way to get it working?
thx in advance