Just echo a link of the form Click for
lyrics 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 database, how can I create a link so that w
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
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 ec
t; <[EMAIL 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 &qu
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 , lyr
