Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Product Search Algorithm

What's the best approach for searching products?

12:21 pm on Oct 29, 2008 (gmt 0)

Junior Member

10+ Year Member

joined:July 21, 2008
votes: 0

Just adding on a PHP search facility to my e-commerce site and struggled to find an answer for this.

I haven't utilised a plaintext search (mysql) for my products search, but have several fields I'd like to search. Was going to do a keyword density approach for each of the below fields, and weight it using the following:-

40% weight = Product Title
20% weight = Product Description
20% weight = Meta Tags (title/description/kw)
20% weight = Other fields

$weighting = array("title"=>0.4, "description"=>0.2, "meta"=>0.2, "other"=>0.2);

Are there quicker or better ways to do this / am I missing a trick?

2:00 pm on Nov 12, 2008 (gmt 0)

Senior Member

WebmasterWorld Senior Member dreamcatcher is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Mar 30, 2003
votes: 0

How about MySQL`s FULLTEXT search functions?