Welcome Guest, Not a member yet? Register   Sign In
problem when cleaning a query
#1

[eluser]ahmedi[/eluser]
I have a blocking problem with an sql query , here is my code
$term = $this->db->escape($tag);
$request = "SELECT * from tags WHERE tag REGEXP '[[:<:]]".$term."(s|es)*$'";

When this query is executed i obtain form example for $tag='test' ;

$request = "SELECT * from tags WHERE tag REGEXP '[[:<:]]'test'(s|es)*$'";
which is not good because i have quotes around test word, how can i avoid this probelme
thanks


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



Theme © iAndrew 2016 - Forum software by © MyBB