Forum Moderators: phranque

Message Too Old, No Replies

Affiliate Search Function

What do you use?

         

johnser

2:08 pm on Jun 22, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Large affiliate site with 100K products listed

Each product has it's own title & description from the retailer.

The search tool we have is pretty basic and misses a lot despite our best efforts.

Whats the best (php/mysql) site search tool to implement that allows users who search for "blue dogs" to actually find products like "blue dogs / blue dog products / cheap blue dog"

(And not, "dog food as used by blue dogs")

There must be good search solutions out there that use word stemming / dictionaries / thesaruses etc?

Are there any that don't cost $3million+?
What do you use?

badone

1:17 am on Jun 24, 2006 (gmt 0)

10+ Year Member



Look into "full text search" in MySQL and maybe look at something like HTDIG (is it still around?).

You could suck the relevant portions, or even the whole page into the database and then run a full text search on it. I did a similar thing several years ago with a postgres database but the relevant info was already in the database.

HTH,
BAD

johnser

2:06 pm on Jun 24, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thx badone - does this do word stemming & similar?
J