Need to escape the % key in mysql query

[Anon]

I need to deactivate the % key on a form in a web page.

my query is : Select * from users where :
if ($un)

       $searchStmt .= "$table[1] like '%$un%' and " ;
    if ($deux)

       $searchStmt .= "$table[2] like '%$deux%' and " ;
    if ($trois)

       $searchStmt .= "$table[3] like '%$trois%' and " ;
    if ($quatre)

       $searchStmt .= "$table[4] like '%$quatre%' and " ;
    if ($cinq)

       $searchStmt .= "$table[5] like '$cinq' and " ;
    if ($six)

       $searchStmt .= "$table[6] like '%$six%' and " ;
    if ($sept)

       $searchStmt .= "$table[7] like '%$sept%' and " ;
    if ($huit)

       $searchStmt .= "$table[8] like '%$huit%' and " ;
    if ($neuf)

       $searchStmt .= "$table[9] like '%$neuf%' and " ;

$stmt= substr($searchStmt, 0, strlen($searchStmt)-4) ;

$un.....$neuf are textfields. But if a write % in a textfield or another all of my data appears on the screen.

i want to "MASK" that %

any ideads folx? I couls use a javascript but i dont have any books right now...

[Anon]

Why do you need to deactivate the %? The way you have it written should be fine. If not, you could try concatenating the variable into the line as follows:

$searchStmt .= "$table[int] like '%". $var ."%'";

[reagent]

not if $var == '%'

does str_replace('%' '\%', $text)

do anything for you?