[SQL HELP] please read this one....

[DiL]

i have an SQL query line that is

$nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM table_inbox WHERE senderid='".$senderid."' AND flag='0'"));

but i want to count that by using GROUP BY ...

can i count that by using "group by"

[m4ster_v4]

i have an SQL query line that is

$nopm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM table_inbox WHERE senderid='".$senderid."' AND flag='0'"));

but i want to count that by using GROUP BY ...

can i count that by using "group by"

$nopm = mysql_fetch_array(mysql_query("SELECT COUNT(DISTINCT user) FROM table_inbox WHERE senderid='".$senderid."' AND flag='0'"));

replace user with your group by.

example Group by lala

Then, DISTINCT lala

Good luck.

[DiL]

hey thanks buddy... its working for me... you solved my problem...

but can i ask one more question ??

whats the meaning of DISTINCT ??

and its full name ?...
i want to get some knowledge about that... thanks in advance

[m4ster_v4]

hey thanks buddy... its working for me... you solved my problem...

but can i ask one more question ??

whats the meaning of DISTINCT ??

and its full name ?...
i want to get some knowledge about that... thanks in advance

Only count different value from sql.