You seem to be doing it fine as far as I can see, except for song_id which should be
songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have three tables set out below:
xp_artist: artist_id , artist _name
xp_sings: artist_id , songs_id
xp_songs: songs_id , song_name , lyrics
I
PROTECTED]
To: Barry Rumsey [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 1:51 PM
Subject: Re: [PHP-DB] help on mulit query
You seem to be doing it fine as far as I can see, except for song_id
which should be songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have
Your query looks fine, except that it should be xp_sings.songs_id. What you
are trying to resolve is a many to many relationship where many artists can
sing the same song, hence you have created the table xp_sings. This is also
known as a pivot table.
What problem are you having?
Have you
: Monday, January 07, 2002 1:51 PM
Subject: Re: [PHP-DB] help on mulit query
You seem to be doing it fine as far as I can see, except for song_id
which should be songs_id in the query...
Bogdan
Barry Rumsey wrote:
Hi
I have three tables set out below:
xp_artist: artist_id
Just echo a link of the form a href=\lyrics.php?song_id=$song_id\Click for
lyrics/a and use the incoming song_id in lyrics.php to get it from the
database.
Bogdan
Barry Rumsey wrote:
I did not see that ( I must be blind hehe ). One other question , I have the
lyrics also stored in the