[Icy Phoenix Debug] PHP Notice: in file /music.php on line 26: main(MEDIA_MOD_PATHmusic_common.php) [function.main]: failed to open stream: No such file or directory [Icy Phoenix Debug] PHP Notice: in file /music.php on line 26: main() [function.include]: Failed opening 'MEDIA_MOD_PATHmusic_common.php' for inclusion (include_path='.:/usr/lib/php') [Icy Phoenix Debug] PHP Notice: in file /includes/page_header.php on line 1189: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2004) [Icy Phoenix Debug] PHP Notice: in file /includes/page_header.php on line 1191: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2004) [Icy Phoenix Debug] PHP Notice: in file /includes/page_header.php on line 1192: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2004) Lordz of Chaos
SELECT c.*, COUNT(s.song_id) AS count
FROM MUSIC_CAT_TABLE AS c
LEFT JOIN MUSIC_TABLE AS s ON c.cat_id = s.song_cat_id
WHERE cat_id <> 0
GROUP BY cat_id
ORDER BY cat_order ASC
Forum 
