создаю две табы
create table m_tema_music (id INTEGER AUTO_INCREMENT, name TINYTEXT, KEY Id_key (id) );";
create table m_music (id INTEGER AUTO_INCREMENT, name TINYTEXT, idtema INTEGER, file TEXT, zahod TINYTEXT, golos TINYTEXT, KEY Id_key (id) );";
Выполняю запрос
$query = "select m_music.id as idd, m_music.name as nn, m_tema_music.name as tema, m_music.golos as gg from m_music, m_tema_music where (m_music.idtema=m_tema_music.id) ORDER BY m_music.golos DESC";
Сортировать по полю golos не хотит
-->
http://www.mtsgsm.ru/index.php?action=music