Hi, First let me explain the logic behind here :) We have a list of "images" in a mySQL DB, which we are indexing (fine)
We have the following fields: 1) description - a text field, separated by whitespace 2) keywords - a text field, separated by whitespace 3) download_count (a "sint", i.e sortable int) What we are doing currently is: (keywords:"st" AND keywords:"patricks") OR (description:"st" AND description:"patricks") ...and then doing the "sort" with: score desc, download_count desc The results work ok, but ideally we would like to give higher priority for those links that match the query, and then have a higher "download_count" value For example, we have say 2 records: Keywords: st patricks some other keywords here Description: st irish holiday View Count: 54343 Keywords: st patricks some other keywords here Description: st patricks irish holiday View Count: 543 The 2nd record would currently show up higher for me, due to the fact we have "st patricks" in both the "keywords" and "description" fields... but what we ideally want, is for the "view count" to actually increase the ranking a bit more, to hopefully bring the results higher up We've tried doing stuff like: sort=download_count ..but that doesn't do what we need (it simply sorts by the number of downloads, instead of giving a higher ranking based on the number of views) I've had a look on google regarding this, but can't seem to find anything like the above. Any ideas/advice are much appreciated :) TIA -- Andy Newby a...@ultranerds.com
