
February 20th, 2000, 11:48 AM
|
|
Junior Member
|
|
Join Date: Feb 2000
Location: Denmark
Posts: 7
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
I am working on a little project, I need to make some lookups in a MySQL table.
Table:
ID name type
1 John a
2 Martin a
3 Winston c
4 Mark b
5 Bill b
I then need to make a list of which types there are. EG:
Types:
a
b
c
And I also need to make a count of how many of each type there are EG:
Type Count
a 2
b 2
c 1
I am using PHP3 to interface the MySQL db, how can I do this?
--
Anders
|