[b]Like function in select statement[/b]

[hecheng]

the following is my mysql_query statement

 

$result=mysql_query(\"select * from elementary where Location like \'%\".$_POST[\'textfield\'].\"%\'\", $mylink);

 

If I input inToronto for my search string,

the result does not output the records that have

Toronto in them.

 

could anybody explain how i can fix the problem?

 

Thank you!!!

 

 

 

[akitchin]

i\'ve had difficulties including $_POST variables in mysql queries before. see if this helps:

 

$search = $_POST[\'textfield\'];

$result = mysql_query("SELECT * FROM elementary WHERE location LIKE \'%$search%\'", $mylink);

 

cheers

[effigy]

you can also enclose the POST in braces like so:

 

$result = mysql_query(\\\"SELECT * FROM elementary WHERE location LIKE \'%{$_POST[\'textfield\']}%\'\\\", $mylink);