hi,

Ive got a table with a number of records in :-

username | time
----------------------
ash | 0.01
ash | 0.04
ash | 1.12
lee | 0.23
lee | 2.34

I know how to count the number of records in the DB, but if you look at the table above there are two users that have records in this DB i want to know how i can count this, so the value now would be '2', but if another person was added to this table e.g:-

username | time
----------------------
ash | 0.01
ash | 0.04
ash | 1.12
lee | 0.23
lee | 2.34
dave | 0.43
lee | 4.32
ash | 0.12

i want that value to change to '3' as there are now 3 different people in the DB. The username field is unique meaning no two people can have the same.

Does anyone know how to do this? even if i jst get the method of SQL statement i could look it up

cheers
Ash:)

My new web design domain
www.askmultimedia.co.uk

__________________
My new web design domain
www.askmultimedia.co.uk

SELECT ~ GROUP BY username;
Suggestion: Use normaized tables, instead.

This is also possible.

Select Count(Distinct username) From <TableName>

Regards

DMK