Re: alternatives? (Was: Shot in the dark)

John, If you're still doing the query from earlier in this thread, which I believe was: mysql_query("SELECT * FROM $table WHERE MATCH (AU) AGAINST ('.$au.') order by AU desc"); And you did: ALTER TABLE ccl_main ADD FULLTEXT(AU,AUS); And you're getting: Can't find FULLTEXT index matching the column list I'd take that to mean that there isn't a FULLTEXT index matching the column list you used in the query (AU only). Maybe "... WHERE MATCH (AU,AUS) AGAINTS..." would work better, since that's the FULLTEXT index you actually created? I'm not sure -- I'm only familiar enough with MySQL FULLTEXT searching to have determined that it didn't work for my needs. I suggest taking this issue over to the MySQL list at this point, since it's no longer a PHP-related issue. -Clay > From: jtjohnston <taylorjo@collegesherbrooke.qc.ca> > Reply-To: jtjohnston@courrier.usherb.ca > Date: Sat, 06 Jul 2002 16:49:53 -0400 > To: php-general@lists.php.net > Subject: Re: [PHP] alternatives? (Was: Shot in the dark) > > 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'; > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >