Code: Select all
$musiclist=mysql_query("SELECT subcat FROM subcat WHERE category='Music' ORDER BY subcat");
$sublist=array(1=>array('Anna','Andrew','Andrea','Annakin'),
2=>array('Bill','Bob','Bernie'),
3=>array('Charles','Camila','Connie','Constance'),
'Music'=>mysql_fetch_array($musiclist),
5=>array('Edmund','Edgar','Elisabeth','Eugene','Emma','Emily'));