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 when the query is returned they can click on song name and the lyrics will be viewed? ----- Original Message ----- From: "Bogdan Stancescu" <[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 "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 can not figure out how to query and return the results for a query like: > > > > "select song_name FROM xp_artist,xp_sings,xp_songs WHERE xp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id = xp_songs.songs_id AND artist_name LIKE 'b%'"; > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
