How do I count Uniques in mySQL ??

[jeddi]

Hi,

A table which consists of lines with several entries for the same client
and I want to count how many different clients there are.

So I need to count only the number of uniques.

This is what I have:

PHP Code:

$sql_cnt = "SELECT item_id FROM main WHERE platform_no = '$platform_id' AND plat_type = '$Db_type'";

$result_cnt = mysql_query($sql_cnt)    or die("could not count the ITEMS". mysql_error() );  

$num_cnt = mysql_num_rows($result_cnt); 


I NEED TO ADD SOMETHİNG LİKE :

PHP Code:

$sql_cnt = "SELECT item_id FROM main WHERE platform_no = '$platform_id' AND plat_type = '$Db_type AND client_no IS UNIQUE'";

$result_cnt = mysql_query($sql_cnt)    or die("could not count the ITEMS". mysql_error() );  

$num_cnt = mysql_num_rows($result_cnt); 


Does anyone know what the proper syntax is for this query ?

thanks.


.

[Thyrosis]

Something like this should do the trick I guess.

PHP Code:

$sql_cnt = 
"SELECT client_no
FROM main
WHERE platform_no = '$platform_id'
AND plat_type '$Db_type'
GROUP BY client_no"; 


[jeddi]

Thank you-

I will give that a try

[hinch]

PHP Code:

$sql_cnt = "SELECT DISTINCT item_id FROM main WHERE platform_no = '$platform_id' AND plat_type = '$Db_type'";

$result_cnt = mysql_query($sql_cnt)    or die("could not count the ITEMS". mysql_error() );  

$num_cnt = mysql_num_rows($result_cnt); 


[ahamadhussain]

Hai Buddies....
Already I have facing same problem select the unique name...so, this code also worked properly...
$sql_cnt = "SELECT DISTINCT item_id FROM main WHERE platform_no = '$platform_id' AND plat_type = '$Db_type'";

$result_cnt = mysql_query($sql_cnt) or die("could not count the ITEMS". mysql_error() );

$num_cnt = mysql_num_rows($result_cnt);

[ahamadhussain]

Hai Buddies...
Already i have facing the same problem. select the unique thing from database
I also worked the following query...
$sql_cnt = "SELECT DISTINCT item_id FROM main WHERE platform_no = '$platform_id' AND plat_type = '$Db_type'"; \\Used DISTINCT

$result_cnt = mysql_query($sql_cnt) or die("could not count the ITEMS". mysql_error() );

$num_cnt = mysql_num_rows($result_cnt);

[tinaliy]

I will help you to check it too.