Re: Best way to store songs in sql db

actually it is a much better way to split up the tracks and albums. in the albums you can give an id number, and on the tracks table, you can use the same id number to see that which track belongs to which album. As a result of this you will not have to try not printing the empty tracks and also your tables will use less space. Also let's think you have made your table for 20 tracks maximum, what if you get a 21 track cd? Will you not buy it? :) -- ------------------------ Omer Barlas obarlas@moyaweb.com obarlas@barlas.com.tr obarlas@artemis.efes.net ------------------------