How to perform a best match search with SQL Lite?
Posted: Sat Mar 07, 2009 6:53 am
Hi,
I have a html page of selection boxes which contain features of a product, and I have a database that contains a selection of product packages that contain different features.
What I'd like to know is how can I search the database based on the product features the customer chooses and return which package best suits their needs?
I know how connect to the database, perform queries and send and recieve data, but I can't work out how to do a best match search based on many fields.
Any help is greatly appreciated
I have a html page of selection boxes which contain features of a product, and I have a database that contains a selection of product packages that contain different features.
What I'd like to know is how can I search the database based on the product features the customer chooses and return which package best suits their needs?
I know how connect to the database, perform queries and send and recieve data, but I can't work out how to do a best match search based on many fields.
Any help is greatly appreciated