I am looking for the best solution to my situation:
- I have businesses listed in a MySQL table.
- Each business can bid on up to 10 keywords (different prices for different keywords).
A user inputs a keyword and then I must find a way to query my table and get out the business matching that keyword by order of bid.
Your help would be very appreciated.