I'm new to MySQL and PHP. I'm able to create a drop down list that displays the contents of one field (category) [ using the DISTINCT clause in the select statement]. What I'm having difficulty with is displaying the data on the selection of data in the drop down list. The field in the database that I'm using to test this is:
category
description
url
When a person selects a new value from the drop down list, I want the page to refresh and clear the old data grid.
Any help is appreciated.