I've got a really hard one!

[jk11uk]

(ehem, php question that is)

 

I have a search indexing script that puts a weighting to each of the words in an item (item has title, body text and tags) and puts these in a database as:

 

id

item_id

word

weight

 

So, when someone types in a search phrase i need to:

split the phrase up into words

search the words database for each of the search phrase words and return a top 10 set of item IDs, each of which should also have a weighting score ('weight' from the database)

then when this is done for all search words, all of the weightings for unique IDs are added up and then the list of items is displayed, ordered by total score (weightings added up)

 

 

any genius help out?

 

 

thanks very much in advance