need some advice on the best way to make a search page in php for a mysql database.
The database contains 3 columns with CSV's. The CSV's are all taken from a set list of about 20 different values.
I want users to be able to search for each row for different values using dropdowns or checkboxes.
For example, for row 1:
column a = "apples, pears, oranges"
column b = "red, black, green"
column c = "wood, stone, water"
so a user might want to find a row with columns a, b or c containing ALL of apples, oranges, red and stone **OR** ANY of apples, oranges, red and stone (preferably in the latter case sorted by the number of matched occurrences).
I'm familiar with the syntax for a basic search, but can't put together a query for this that does what I want it to.
Thank you in advance....
The database contains 3 columns with CSV's. The CSV's are all taken from a set list of about 20 different values.
I want users to be able to search for each row for different values using dropdowns or checkboxes.
For example, for row 1:
column a = "apples, pears, oranges"
column b = "red, black, green"
column c = "wood, stone, water"
so a user might want to find a row with columns a, b or c containing ALL of apples, oranges, red and stone **OR** ANY of apples, oranges, red and stone (preferably in the latter case sorted by the number of matched occurrences).
I'm familiar with the syntax for a basic search, but can't put together a query for this that does what I want it to.
Thank you in advance....