Re: alternatives? (Was: Shot in the dark)
| From: | jtjohnston | Date: | Sat, 06 Jul 2002 20:49:53 +0000 |
| Subject: | Re: alternatives? (Was: Shot in the dark) | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102599@lists.php.net to get a copy of this message | ||
Clay,
I ran:
ALTER TABLE ccl_main ADD FULLTEXT(AU,AUS)
But this still errors "Can't find FULLTEXT index matching the column list"
$news = mysql_query("SELECT * FROM $table WHERE MATCH (AU) AGAINST ('.$au.') order
by AU desc");
I even reloaded MySQL.
CREATE TABLE ccl_main (
id int(6) NOT NULL auto_increment,
...
AU text NOT NULL,
...
AUS text NOT NULL,
...
PRIMARY KEY (id),
FULLTEXT KEY AU (AU,AUS)
) TYPE=MyISAM COMMENT='CCL Bibliography - Bibliographie ECC';