fulltext searches on linked table query

[gte604j]

Hi,

I am having problems doing a full text search with multiply tables involved.

I have a table items: id,name,description that i have a fulltext set on the name and description

i then have a category table: id,name

then a table to link the two itemCat: iid,cid

so when i do this it works:

select i.id,i.name from items i where match (name,description) against ('toys');

but when i do something like:

select i.id,i.name from items i, itemCat ic, category c WHERE ic.iid=i.id and ic.cid=c.id and c.id='$catToSearchIn' AND MATCH (name,description) AGAINST ('toy')

I cant get it to work I have tried moving the match statement around but i keep getting a syntax error where i state MATCH no matter what

jake

[TTT]

you have to use INNER JOIN

select i.a as a
from tableA a INNER JOIN tableB b ON a.id = b.id

[chriskl]

He IS using an inner join - that's what the comma means...

Try doing this maybe:

select i.id,i.name from items i, itemCat ic, category c WHERE ic.iid=i.id and ic.cid=c.id and c.id='$catToSearchIn' AND MATCH (i.name,i.description) AGAINST ('toy')