I'm currently building a CMS for a client, and one of his requirements is to have a section which shows his firms ranking against other firms with the data he enters, and perhaps, display a graph or chart for output.
(I know this sounds a little vague right now, but im looking for some info before I request any more info from him) if there was an open source ASP script out there that does this type of thing.
I'm wondering how I can rank search results based on how close the result is to the search term. For example, I have a database that includes a field for position title. When a user searches for the title "President", they are shown a list of everyone with the word "President" somewhere in their title.
However, I want to show the records for the presidents above the records for the vice presidents. So I guess I should say that I want to show exact matches first, then loose matches afterwards. Can anyone tell me how to get started on this?