[SOLVED] Counting DIFFERENT values in a MySQL table

[spiceydog]

I have figured out how to get MySQL to count how many rows there are with the SAME name in a specific value but I need it to count the number of DIFFERENT values there are in a specific value. For instance my current code is:

$query = "SELECT user, count(albumname)

FROM albuminfo

GROUP BY user

ORDER BY albumname";

 

$result = mysql_query($query) or die("Couldn't execute query because: ".mysql_error());

while ($data = mysql_fetch_array($result)){

 

$posts = $data['COUNT(albumname)'];

}

{

echo "$user has $posts post(s)";

}

 

The problem is that I have 6 lines in the database that have the same value for "albumname" and of course they are counted seperately. What I want is for the script to recognize that all 6 lines are exactly the same and only read them as 1.

[cooldude832]

try

SELECT user, COUNT(DISTINCT(albumname)) as albumcount from `albuminfo` ORDER BY albumname

 

check my spelling

 

(The group by is unneeded)

[spiceydog]

thank you!!!!

 

but what is the meaning of the "as albumcount"? i've never seen that before

 

also I am getting this error:

Couldn't execute query because: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

[spiceydog]

SOLVED!!