I would like to list the values of two particular fields in a table. If for example there 10 rows, and the two colums are
a 10
b 3
c 1
c 5
d 3
c 4
e 7
a 9
g 8
f 3
I like to list them in an html table as (the number in parenthese is the number of rows having the same letter):
a (2)
a 10
a 9
b (1)
b 3
c (3)
c 1
c 5
c 7
d (1)
d 3
e (1)
e 7
f (1)
f 3
g (1)
g 8
I am having difficulty with writing the correct mysql queries. Please help.
