a simple (and maybe stupid) question, but it's killing me:
I have a medium-scaled table containing articles (the table holds title, summary, abstracts, keywords, a file system link to a pdf, ..., ...). Now I have to write a fulltext query for this table which should extract all entries whose title or keywords contains one or more of the keywords a user hits into a form.
So i started with creating a fulltect index for the two fields
Code: Select all
ALTER TABLE articles ADD FULLTEXT (title);
ALTER TABLE articles ADD FULLTEXT (keywords);Code: Select all
<?php
$keywords = $_REQUEST["keywords"];
SELECT * FROM articles WHERE MATCH (title, keywords) AGAINST ('$keywords') ORDER BY date DESC;
?>I have tested this query in the command line and in PHPMyAdmin; the result was always an error:
Code: Select all
їThu Apr 15 08:46:08 2004] їerror] PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /export/home/local/Web/include/templates/content/c_articlesearch.inc on line 65
#1191 - Can't find FULLTEXT index matching the column listThanx,
- bluenote