[SOLVED] MATCH - AGAINST Query - help required?

[Teamwolf2000]

Hi,

I wondered if any of you experts could help me.

I am trying to query a keyword table and return the items that are joined to the keyword table via a simple join table. I would like to use the Match Against on the query as a search.

 

The following query works as expected:

 

SELECT GalleryItem.*

FROM GalleryItem, Keywords, KeyItemJoin

WHERE GalleryItem.ID = KeyItemJoin.ItemID

AND Keywords.keyword LIKE  $SearchId

LIMIT 0 , 30

 

Using Match Against include in the query (below) returns Zero results, but should return some results:

 

SELECT GalleryItem. * ,

MATCH (Keywords.Keyword)

AGAINST ($SearchId) AS score

FROM GalleryItem, Keywords, KeyItemJoin

WHERE GalleryItem.ID = KeyItemJoin.ItemID

AND MATCH (Keywords.Keyword)

AGAINST ($SearchId)

LIMIT 0 , 30

 

I am sure its prety simple, but I can not get it to work correctly.

Any help much appreciated.

 

Many thanks.

 

[fenway]

Hard to say without some data... but usally this means too many rows match; full-text indexing is weird like that.

[Teamwolf2000]

Hi,

Thanks for the response.

here is the site it is on:

www.frittendenphotos.co.uk

 

I have also attached the SQL file

 

I would like the search to use the query above to select the items based on the serch text from the keyword table.

 

Many thanks for your help and time.

 

Cheers,

 

[attachment deleted by admin]

[fenway]

Like I said, with only 5 entries, if more than half of the records match, you won't get any results.

[Teamwolf2000]

opps sorry, I didnt understand that its on a percentage basis.

I totaly see what your saying.

 

Many thanks for your help.