Indeed, another problem I have is that if a single is on an album, which
track it is on the album.

I want to centre the site on the Charts that are generated weekly for
singles and albums so if I use that as my source for the lookup and then
have the data contained in separate fields that are linked to this
table. Will that be making things easier or harder?

-----Original Message-----
From: David Freeman [mailto:[EMAIL PROTECTED]] 
Sent: 13 October 2002 22:12
Subject: RE: [PHP] A little help needed, I cant figure!

 > >Song Table:
 > >Song_id
 > >A_id
 > >Type
 > >Name
 > >Length
 > >Lyrics
 > >...
 > >
 > >That's my ideas on how to do it. There are many ways to do 
 > it, though.
 > >
 > Totally agree with what John says. If the lyrics are long 
 > (as I assume 
 > they will be) then I'd probably hive the lyrics off into a table of 
 > their own with as many records as needed to make up one 
 > song. The song 
 > table would then become:
 > Song Table:
 > Song_id
 > A_id
 > Type
 > Name
 > Length
 > Lyric_id
 > and have a lyrics table such as:
 > Lyrics Table:
 > Lyric_id
 > sequence
 > text

Hmm, just thinking about normalizing the data and I suspect that the
song table will be insufficient if you have to take into account songs
that are released as a single and then also released on an album.  You
may find, in that circumstance, that having lookup tables will help.
One of these tables will contain artist ID's and associated song ID's
and enable you to get singles for an artist.  The other table would
contain album ID's and song ID's and enable you to get songs for an
album.  Obviously, you can get much more complex queries going as well
such as the number of times a particular song has been included on an
album by an artist.

This addition would also help with songs on compilation albums by
multiple artists where you could drill down to a list of songs on a
compilation album complete with the artist for each song.

CYA, Dave

PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to