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());


echo $num[0];

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

Thanks guys

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

Reply via email to