Re: help on mulit query

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" <mgv@fx.ro> To: "Barry Rumsey" <webmaster@musicsearch.ath.cx> Cc: <php-db@lists.php.net> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >