Re: help on mulit query
| From: | Miles Thompson | Date: | Mon, 07 Jan 2002 01:34:03 +0000 |
| Subject: | Re: help on mulit query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15469@lists.php.net to get a copy of this message | ||
Barry,
Execute your query, fetching song_id as well as song_name, returning the result handle to $result (or any name you're comfortable with) and present your song titles like so ..
while ($myrow = mysql_fetch_array($result))
{
printf("<a href=\"%s?songs_id=%s\">%s </a> \n", $LYRIC_URL, $myrow["songs_id"], $myrow["song_name"]);
}
This assumes that songs_id is the key for the lyrics in the lyrics table.
Presenting this neatly in a table is left up to you! Have fun.
Miles Thompson
At 02:13 PM 1/7/2002 +1300, 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 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 querylike:"select song_name FROM xp_artist,xp_sings,xp_songs WHERExp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id = xp_songs.songs_id AND artist_name LIKE 'b%'";