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 1
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?
Last edited by andym01480 on Fri Jun 23, 2006 5:46 pm, edited 1 time in total.
Can't find FULLTEXT index matching the column list.
When I took a look at phpmyadmin teh fulltext button is highlighted for both the columns. Is there something I am missing? How can I check that a fulltext index has been done?
You need a composite index for title and description. Not separate ones. Delete the fulltext index for description. Edit the fulltext index for title, and add description as another field in that index.
View the structure of the table.
Hit the red X next to the description fulltext index to delete it.
Hit the pencil next to the title fulltext index to edit it.
Ok, now you are editing it and you see columns for field and size.
Add to index 1 column(s), click Go.
You should see a 2nd field listed at the bottom, it says "--Ignore--" ... change this to the description field.
Hit save.