Welcome to WebmasterWorld Guest from 22.214.171.124
Forum Moderators: phranque
Our site provides online training, and users each have their own file area where they can store files that they have created as a result of their training excersizes. Whenever they submit a file, they must supply a title, plus a short(ish) description. These two elements are stored in a (SQL) database, along with a lot of other seperate values relevant to their training programme.
Now, so far I can extract all matching records from the SQL d/b based on what dropdown box selections the user has made in the "Search Files" section. But - and this is the tricky bit - they can complement their dropdown box selections by completing a "Search Words" text box.
What I would like to do is rank the corresponding results based on each files relevancy to whatever was entered into the "Search Words" form field. Below is the pseudo-code for what I'm planning to implement, and I'd like some feedback on what other users here at WebmasterWorld think;
What do you think? Any and all comments greatly welcomed, and thanks in advance.