Hello I have a problem with my search engien, the point with it that I can find a special word in my tabel.
Like if I have added in my tabel PHP RULEZ AND .NET SUX,
So should I find this line in the tabel when I search on sux or and.
I use MySQL 4.1.13 (xampp)
http://www.apachefriends.org/
I have the Key: in the tabel (or what its called)
ALTER TABLE adds ADD FULLTEXT namnTypFtDescript(Rubrik)
And use this line to get the information in my php-file
$_POST['search'] = $textString;
$str = "SELECT * FROM info WHERE MATCH (Rubrik) AGAINST (\"$textString\" IN BOOLEAN MODE) ORDER BY MATCH (text)";
$res = mysql_query($str) or die(mysql_error() . '<br>' . $str);
$check = mysql_fetch_array($res);
And get this error message:
You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
What do they mean wrong version? I got the newest ver. MySQL 4.1.13? dont I?
SELECT * FROM info WHERE MATCH (Rubrik) AGAINST ("" IN BOOLEAN MODE) ORDER BY MATCH (text)
Is there anyone who can help me?