escape question

[eluser]timotheus[/eluser]
@dadamssg87 - I recently came across the same thing. You want to use:

$this->db->escape_like_str()

Code:

$sql = "SELECT id FROM table WHERE column LIKE '%".$this->db->escape_like_str($search)."%'";

It's found in the Escaping Queries section, option 3.

http://ellislab.com/codeigniter/user-gui...eries.html

@InsiteFX - Sometimes I find Active Record to be more cumbersome than it's worth. I use both methods where it makes sense.