> Indeed, another problem I have is that if a single is on an
> album, which track it is on the album.
Off hand, I'd say that if you need this information as well (ie. You
want to recreate the "songs on album" list in the correct order) then
you need to extend one of your tables to include th
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
To: [EMAIL PROTECTED]
Subject: RE: [PHP] A little help needed, I cant figure!
> >Song Table:
> >Song_id
>
> >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
John W. Holmes wrote:
>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 o
[snip]
> For example I intend to have over 4,000 different charts covering well
> over 6,000 artists and over 26,000 singles and album titles. Could
mySQL
> and PHP cope with this demand?
Yes, easily. Make sure your tables are properly indexed.
> I thought about having a table for Artists, one
5 matches
Mail list logo