Search Results Order
I have created a search field on my database which allows users to search for a particular word on the database, and it will result all the records that match this. However what I want is for the results of the search to be in a particular order.
I have many different companies on the database, when a user searches for "iPhone", I want the company which we recommend to purchase iPhones from to appear first on the search results. I am not too sure how to implement this.
Any help would be much appreciated.