Counting entries in a SQL Table

[dennismonsewicz]

I was wondering if there is a way to count a number of entries in a SQL table?

 

For example:

 

If you have a field in the table named uploaded_username, and you want to count how many times a particular name shows up in that table.

 

How would I achieve this? Sorry for the n00b question

[Barand]

to count a single name

 

SELECT COUNT(*) as total FROM tablename WHERE uploaded_username = '$username'

 

to count all names

 

SELECT uploaded_username, COUNT(*) as total FROM tablename GROUP BY uploaded_username

[dennismonsewicz]

Thanks bud, I figured out the problem I was having!