SELECT COUNT(`трэк`) FROM `музло` GROUP BY `пИвец`

2
1

SELECT `пИвец` FROM `музон` GROUP BY `пИвец`

<?php
include('include/db.php');
mysql_query('SET NAMES cp1251');
$cat = $_GET['cat'];
$result_music = mysql_query("SELECT `album` FROM `music` GROUP BY `album`");
$myrow_music = mysql_fetch_array($result_music);
?>

<?php 
do {
echo $myrow_music['album']."<br>";
}
while(mysql_fetch_array($result_music));
?>

SELECT `name`, `album` FROM `music` GROUP BY `album`

$query = 'select count(distinct `album`) from `music`';
$res = mysql_query($query) or die(mysql_error());
$count = mysql_result($res, 0);

var_dump($count);

$query = 'select distinct `album` from `music`';
$res = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($res))
  var_dump($row);

SELECT `name`, `album` FROM `music` GROUP BY `album`

Трек1  Дома
Трек2  Город дорог

mysql_query('SET NAMES cp1251');

mysql_set_charset('cp1251');

<?php 
$result_block = mysql_query('select distinct `album` from `music`');
while ($row = mysql_fetch_assoc($result_block)){
  echo $row['album'];
  }
?>