MySQL LIKE + php sprintf

drydrofabuppy

New Member
\[code\]$test = sprintf("SELECT * FROM `table` WHERE `text` LIKE '%%s%'", mysql_real_escape_string('test'));echo $test;\[/code\]output:\[code\]SELECT * FROM `table` WHERE `text` LIKE '%s\[/code\]but it should output:\[code\]SELECT * FROM `table` WHERE `text` LIKE '%test%'\[/code\]
 
Back
Top