06-07-2012, 05:04 AM
[eluser]veledrom[/eluser]
Hi,
How can I remove single quote from query?
Thanks
- Generated as:
- Should be:
Hi,
How can I remove single quote from query?
Thanks
Code:
$sql = ".........ORDER BY Distance ASC LIMIT ? OFFSET ?";
$this->db->query($sql, array($limit, $offset));
- Generated as:
Code:
ORDER BY Distance ASC LIMIT '10' OFFSET 0
Code:
ORDER BY Distance ASC LIMIT 10 OFFSET 0