Adding More Genres
Posted: Tue Nov 22, 2005 11:38 pm
well after finally getting close to my media filestructure and renaming all the media and making sure that the albums have the correct id3 tags ( ) I noticed that the genre list is just a sample...
well I took the list that is in WMP and put it into the sql file but since each genre is in a specific letter listing I thought that since I have a total of like 127 different genres that I could use a number instead... for instance
I know this isn't correct but I don't know what the line is exactly off the top of my head:
then just continuing the list but changing the number and increasing it by 1
but it doesn't work. So my question is do the genre have to be ordered using the alpha system instead of numbers and if so if there a easier way of adding 100+ genres?
Anyone have any ideas? Or atleast steer me in the right direction
any and all help is greatly appreciated....
well I took the list that is in WMP and put it into the sql file but since each genre is in a specific letter listing I thought that since I have a total of like 127 different genres that I could use a number instead... for instance
I know this isn't correct but I don't know what the line is exactly off the top of my head:
Code: Select all
INSERT INTO genre ('1' , 'Alternative');
but it doesn't work. So my question is do the genre have to be ordered using the alpha system instead of numbers and if so if there a easier way of adding 100+ genres?
Anyone have any ideas? Or atleast steer me in the right direction
any and all help is greatly appreciated....