Hi
I know that to select multiple rows from MySQL and echoing them I should use the WHILE function to loop it and run it again and again.

My question is however, slightly different. Let's say I have 4 columns in my database titled A, B, C, and D.

I want to select all rows where A= a certain value. I want to group together all rows that have equal values for B and C. e.g. this would show:

B,C
-D
-D
-D

B,C
-D
-D
-D

etc.

Any idea how I can do this? I know the value of A but I do not know the values of B and C beforehand, I just want to group them together if they're the same!

Thanks