[PHP-DB] SELECT Count - solved

[[EMAIL PROTECTED]]

Thanks for the debug advice - I will start using my_sql_error

First I got this error:
Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if 
there is no GROUP BY clause

So the correct code ended up:

$sql = "SELECT COUNT(bandid), genre
FROM bands, genre
GROUP BY genre";

$result=mysql_query($sql) or die(mysql_error());

$num=mysql_fetch_row($result);

echo $num[0];

while ($gen=mysql_fetch_row($result)) {
echo $gen[1];
}


Thanks guys


---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard