problem when cleaning a query

problem when cleaning a query

El Forum
Guest

11-10-2009, 08:44 AM

[eluser]mah0001[/eluser]

Code:
$request = 'SELECT * from tags WHERE tag REGEXP '. $this->db->escape('[[:<:]]'.$term.'(s|es)*$'); 

//or

$sql = "SELECT * FROM tags WHERE tag REGEXP ?";

$this->db->query($sql, array('[[:<:]]'.$term.'(s|es)*$'));

I have not tested, but it should work.

Messages In This Thread

problem when cleaning a query - by El Forum - 11-09-2009, 05:10 PM

problem when cleaning a query - by El Forum - 11-09-2009, 05:58 PM

problem when cleaning a query - by El Forum - 11-10-2009, 07:22 AM

problem when cleaning a query - by El Forum - 11-10-2009, 08:44 AM