Suppose I have a query like that:
SELECT * FROM table WHERE table.a = 23 AND table.b = 23 AND (23 - table.c)/23 > 0.2
This may not have any sense because it is just an example. My real query is much bigger than this one. As you can see, all the values to be binded are equals.
So, how can I use CodeIgniter data binding for this query if all
? are the same data?
Repeting values like this on an array looks strange on code:
$sql = "SELECT *" ." FROM table" ." WHERE table.a = ?" ." AND table.b = ?" ." AND (? - table.c)/? > 0.2"; $this->db->query($sql, array(23, 23, 23, 23);