Hi all. i got a huge list of mp3 that they are in diffrent folders. I put all the songs infor in mysql database in a table called files. I want a query db that output foldernames for me .The folder name is part of feiled called filename in files table. The value of filename is like this :
album1/song1.mp3
album2/song4.mp3
where the bold part is the foldername i want to print for all folders.mp3s is the root folder for mp3s.
Furthermore, i want a query that list all feilds info for songs in each given folder.What i mean is that for each folder it lists all songs info iside that folder.I want to be able to tell the query what folder i want to list its song.Thanks
album1/song1.mp3
album2/song4.mp3
where the bold part is the foldername i want to print for all folders.mp3s is the root folder for mp3s.
Furthermore, i want a query that list all feilds info for songs in each given folder.What i mean is that for each folder it lists all songs info iside that folder.I want to be able to tell the query what folder i want to list its song.Thanks