Warning message in mysql_fetch_array($result)

hatubla

Hi everybody.

My question is regarding warning message:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

This message appeares when I use mysql_query:

$result=mysql_query("SELECT * FROM links WHERE MATCH (description) AGAINST ('cars')"); and then try to fetch result.
Field description filled correctly and I have no problems with
another querries.
What is wrong ?

laserlight

This might help:
http://www.mysql.com/doc/en/Fulltext_Search.html

I've never used MATCH() before, and from that help page the syntax seems to be ok.
Perhaps the problem is that you didnt declare:
FULLTEXT (description)
when creating the table?

hatubla

Thank you aserlight.
You was right. Including of FULLTEXT index resolved the problem
with warning message and and fulltext search request is working.
However, new problems arise. Result of search is strange.
Some words are searchable, another aren't.
For example there is field with text:
Tons of information for the Audi S4
Word "Tons" is not searchable but "information" is searchable ?
Why ?
Below is working script with attached data file. so you can check
how it works.
Any recommendation.
Thanks.

<?php

$dbname="a7a320";

$links_tablename="links";
$links_def="domain CHAR(50), ";
$links_def.="title VARCHAR(50),";
$links_def.="description TEXT,";
$links_def.="FULLTEXT (description)";

mysql_connect("localhost");
mysql_create_db ($dbname);
mysql_select_db ($dbname);

mysql_query("CREATE TABLE links ($links_def)");

$fp=fopen("links.txt", "r");
while(!feof($fp))
{
$domain =fgets($fp);

$title =fgets($fp);

$description=fgets($fp); echo $description; echo "<br>";
$empty =fgets($fp);

mysql_query ("INSERT INTO links VALUES('$domain','$title','$description')");
}
fclose($fp);

echo "<br> --------------------------------------------------------- <br>";

$result=mysql_query("SELECT description FROM links WHERE MATCH
(description) AGAINST ('tons')");

while($row = mysql_fetch_array($result))
{
echo $row[0]; echo "<br>";
}

mysql_query("DROP DATABASE $dbname");
mysql_close();