Like function in select statement

[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!!!

 

[swampBoogie]

Check that the query looks ok

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