RE: mysql: Count & Unique

[Willem Bison]

SELECT COUNT(*) as num FROM tbl_name

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Darren Sweeney
Sent: Saturday, January 16, 1999 22:27
To: MySQL
Subject: mysql: Count & Unique

Hi

 

How do I return a string value from SELECT COUNT(*) FROM tbl_name ?

 

e.g. $count = SELECT COUNT(*) FROM tbl_name

 

Also,

 

Lets say I have 100 lines of data from 10 users ... 10 lines each ... how do I select only one line from each user?

 

Do I use the unique statement and does the field have to be indexed? If so, can one index a field which is already created?

 

Thanks, as always, for all help.

 

Darren