Searching with fulltext in mysql

[sdizier]

The weird thing that i am finding about fulltext searches is that it works fine except for certain keywords

the code i am using in php is this

$query = @("SELECT * FROM $dbTable WHERE MATCH(name,header,body) AGAINST ('$searchString')", $dbc)
or die("Could not alter the table <b>$dbTable!</b>");

while($row = mysql_fetch_assoc($query)){	
$head = $row["header"];
$id = $row["articalID"];
print $head<br>";	
}

Which works fine except when i use words such as asp or php. Even though i have data in my tables with this information. The odd thing is searching mysql works.

Any ideas or help?

Thanks in advance
Slan

[Olorien]

The bad thing about the 'like' command is, that the search string must at least consist of 4 letters. Search strings like 'php' or 'sql' therefore do not work.

Try the MATCH AGAINST function to get rid of that problem.

Greetings
Olaf