[RESOLVED] FULLTEXT problems

[VisionsOfCody]

Hi

I'm trying to work out how to use fulltext searching and I'm having problems with it

here's my table :

CREATE TABLE products (
familyNum smallint(6) NOT NULL default '0',
pageType smallint(6) NOT NULL default '0',
imageURL mediumtext NOT NULL,
pdfURL mediumtext NOT NULL,
productVars1 text NOT NULL,
productVars2 text NOT NULL,
productVars3 text NOT NULL,
productVars4 text NOT NULL,
productRef1 varchar(100) NOT NULL default '',
productRef2 varchar(100) NOT NULL default '',
productRef3 varchar(100) NOT NULL default '',
productRef4 varchar(100) NOT NULL default '',
titreRouge text NOT NULL,
titreNoir1 text NOT NULL,
titreNoir2 text NOT NULL,
titreNoir3 text NOT NULL,
titreNoir4 text NOT NULL,
norme1 mediumtext NOT NULL,
norme2 mediumtext NOT NULL,
norme3 mediumtext NOT NULL,
norme4 mediumtext NOT NULL,
gantNorme1 mediumtext,
gantNorme2 mediumtext,
gantNorme3 mediumtext,
vetNorme1 mediumtext,
vetNorme2 mediumtext,
vetNorme3 mediumtext,
oreilleL tinytext,
oreilleM tinytext,
oreilleH tinytext,
oreilleSNR tinytext,
prodLogo1 mediumtext,
prodLogo2 mediumtext,
prodLogo3 mediumtext,
prodOnline tinyint(4) NOT NULL default '0',
KEY familyNum (familyNum),
FULLTEXT KEY productVars1 (productVars1),
FULLTEXT KEY productVars2 (productVars2),
FULLTEXT KEY productVars3 (productVars3),
FULLTEXT KEY productVars4 (productVars4),
FULLTEXT KEY productRef1 (productRef1),
FULLTEXT KEY productRef2 (productRef2),
FULLTEXT KEY productRef3 (productRef3),
FULLTEXT KEY productRef4 (productRef4),
FULLTEXT KEY titreRouge (titreRouge),
FULLTEXT KEY titreNoir1 (titreNoir1),
FULLTEXT KEY titreNoir2 (titreNoir2),
FULLTEXT KEY titreNoir3 (titreNoir3),
FULLTEXT KEY titreNoir4 (titreNoir4)
) TYPE=MyISAM;

when i search with

"SELECT productVars1, MATCH (productVars1) AGAINST ('support') AS score FROM products WHERE MATCH (productVars1) AGAINST ('support')"

it returns a result - but when i search with

SELECT productVars1,productVars2, MATCH (productVars1,productVars2) AGAINST ('support') AS score FROM products WHERE MATCH (productVars1,productVars2) AGAINST ('support')

I get the SQL error that it can't find a FULLTEXT index for that list of columns

where am i going wrong ?????

thanks ofr any help

[VisionsOfCody]

ah I seem to have worked it out - instead of clicking on the fulltext buttons in phpmyadmin I added the fulltext index using sql and it truned out like this

KEY familyNum (familyNum),
FULLTEXT KEY productVars1 (productVars1,productVars2,productVars3,productVars4,productRef1,productRef2,productRef3,productRef4,titreRouge,titreNoir1,titreNoir2,titreNoir3,titreNoir4)
) TYPE=MyISAM;

also it seems you have to select all of the fulltext columns in the query

• so there you go