Display Data from MySQL


#1

Hi, I have one MySQL table with two columns and about 20K rows. Column A contains duplicate values and Column B contains unique values.

Col A Col B


color red
color blue
color green
fruit orange
fruit apple

I was able to connect and display data successfully on my website. However, I want to be able to display one list of distinct values from Col A, click that value and display all Col B values associated across three columns. For example, I only want to see Col A values

color
fruit

Then when I select color… I want to see all values from Col B associated to color across three columns.

color red blue green
fruit

Does anyone know how to do this or could educate me to accomplish please?

Thank you,