Parse single quotes in query

[eluser]Arun Joshi[/eluser]
Hi,

How to parse single quotes in query? (Normally I replace single quotes with two single quotes by using str_replace function. )
Is there any CI way to do this?

I tried
$this->input->xss_clean() and $this->db->escape() .
But its not working.

Thanks
Arun

[eluser]n0xie[/eluser]
Did you try using active record?

[eluser]Arun Joshi[/eluser]
am using $this->db->query("my query here");

[eluser]shelton_dev_guy[/eluser]
Have you tried to escape each qoute?