MATCH() AGAINST() error [SOLVED]
Posted: Fri Jun 23, 2006 1:36 pm
This code
is producing this error
when $keyword="blah" or anything actually.
I've made title and description fulltext in phpmyadmin, there are currently 4 rows in cart, one of which has the word blah in the description field!
I'm using PHP 5.1.1 and MySQL 5.0.18
What have I done wrong?
Code: Select all
$itemquery="SELECT * FROM cart MATCH(title,description) AGAINST('$keywords')";
$search=mysql_query($itemquery) or die(mysql_error());Code: Select all
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 'MATCH(title,description) AGAINST('blah')' at line 1I've made title and description fulltext in phpmyadmin, there are currently 4 rows in cart, one of which has the word blah in the description field!
I'm using PHP 5.1.1 and MySQL 5.0.18
What have I done wrong?