Simple Select from one table

[ghornet]

From one table I want to count how many of each distict item is in that table. and print it out to the screen.
Thanks from the new guy

Damian

[brandonschnell]

SELECT COUNT(column), column FROM table GROUP BY column

[ghornet]

Thanks that works well, how do I call the column with the count variable in it, so I can put those numbers into an array.

Damian

[ghornet]

I got it select table as (: