i have a php/mysql vehicle database with fields make, model, price and year. in my webpage ALL database records are displayed by default using the select command in a table.
i would like add a filtering functionality on all 4 fields as such i have an arrow selector on each field which when clicked e.g on field make displays all car makes then a user again clicks on a particular make (e.g toyota) the table data recreates to show toyotas only while simultaneously updating the all the other fields' records.
the filters in the other fields e.g price should also simultaneously update ALL fields.
help appreciated greatly