Php-mySQL FULLTEXT problem

[Anon]

Hi,

I'm writing a search engine for my site. When there's only 1 result the script works fine, but from te moment that there are more results, it just shows nothing. I use this script, I think it's correct. Does anyone knows what the problem could be?

$sql = "SELECT * FROM filmvdmaand2 WHERE MATCH (filmvdmaand_title,filmvdmaand_intro,filmvdmaand_body,filmvdmaand_img,filmvdmaand_caption) AGAINST ('$keyword')";
$result = mysql_query($sql) or error_die($err_selectfailed);

$result = mysql_query($sql) or error_die($err_selectfailed);
while ($myrow = mysql_fetch_array($result)) {
echo $myrow['filmvdmaand_id'] . " - ";
echo $myrow['filmvdmaand_time'] . " - ";
echo $myrow['filmvdmaand_title'] . "<br><br>";
}

[bretticus]

make sure you have a good number of records to search from (at least 3 but more is better). Also make sure the text you match with is greater than 3 letters because smaller words are ignored. Finally be wary of the 50% threshold. If a word is found in more than 50% of the rows in the table, it will be discarded.