php/sql search

[hasek522]

hey so i have a search engine i have made that uses FULLTEXT

it is located on hairneedhelp.net  if you want to check it out, anyways it searches city among other things but a couple of the people have La Canada as their city but if i search for "La Canada" it does not show up.  However if i search for "Montrose" that search works fine.  Any ideas how to fix this?

Here is my code:

$search = $_POST['search'];

$search = '%' . $search . '%';

$db = mysql_connect($dbhost, $dbuser, $dbpassword);

mysql_select_db($dbdatabase, $db);

$search = mysql_real_escape_string($search);

$sql = "SELECT * FROM stylists WHERE MATCH(firstname, lastname,address, city, salon, specialty) AGAINST ('" . $search . "');";

$query = mysql_query($sql);

[tpimental]

I'm guessing there is a problem with your PHP code parsing your results.  It seems anything that would return multiple results fails (displays no results).  Searing for the word "on" which is in every name on your site also fails.