Variables into another SELECT (again)

[Anon]

This is the code that I have:
<?php

$x=1;
$artist = mysql_query("SELECT DISTINCT music_artist from music WHERE
music_artist LIKE 'A%'");
while ($myrow=mysql_fetch_array($artist))
{

$art_info = $myrow["music_artist"];
printf('<param name = menu1i1i%s value = "%s">
', $x, $art_info);

$album = mysql_query("SELECT DISTINCT music_album from music WHERE
music_artist = '".$myrow["music_artist"]."'");
$y=1;
while ($myrow=mysql_fetch_array($album))
{

$alb_info = $myrow["music_album"];
printf('<param name = menu1i1i%si%s value = "%s">
', $x, $y, $alb_info);

$y++;
printf('
');
}

$x++;
printf('
');
}
?>

the code is used to populate an applet.
the printf's are used to print the applet tags and to space it out when the html is created.

I inserted the code that you sudgested to me but it never made any differance to what it was before.

I get the artist to come out in order ok...but I get the cd's of both artist for each artist and all the songs from the cd's for each cd.

So I would get Beatles and Beasty Boys fine.
but under Beatles I would get their albums and the Beasty Boys albums. The same holds true for the Beasty Boys. Then I would get all the songs from those albums under each of the Beatles cd's and the Beasty Boys cd's.

I'm starting to get into a panic now...I need this done by the end of the week. lol

Thanks,
Jaymz

[Anon]

you're getting variable collision from using $myrow for three different things, so use something along the lines of;

while ($thisartist = mysql_fetch_array($artist))

for each fetch.

--
rad

[Anon]

I don't know what's happening here but the album loop works fine but the song one is still taking all the songs and putting them in for each cd.

$album = mysql_query("SELECT DISTINCT music_album from music WHERE
music_artist = '".$myrow["music_artist"]."'");
$y=1;
while ($myrow2=mysql_fetch_array($album))
{
$alb_info = $myrow2["music_album"];
printf('<param name = menu1i%si%si%s value = "%s">
', $letter, $x, $y, $alb_info);

$song = mysql_query("SELECT DISTINCT music_song from music WHERE
music_artist = '".$myrow["music_artist"]."'");

$z=1;

while ($myrow3 = mysql_fetch_array($song))

{
$song_info = $myrow3["music_song"];

printf('<param name = menu1i%si%si%si%s value = "%s">
', $letter, $x, $y, $z, $song_info);
printf('<param name = menu1i%si%si%si%surl value ="%s/%s/%s/%s.mp3">
', $letter, $x, $y, $z, $URL, $art_info2, $alb_info2, $song_info2);
$z++;

}

$y++;
printf('
');
}

I have cut out parts that are not necessary to the problem.

My eyes are starting to bug out from looking at it so much. I need a new set (and a set that are more advanced than mine lol) to have a look at it.

After this one is fixed I think I have it done. You guys have helped me out so much I think I'm going to owe you guys a lot of beer for all your help. lol

Cheers,
Jaymz

[Anon]

you need to relate the song to the album in the sql query.

$song = mysql_query("SELECT DISTINCT music_song from music WHERE
music_album=''.'$myrow2["music_album"]."' );

hopefully this should nail it ;-)

--
rad

[Anon]

AHHH...it works!!!!!
You are a good man!!!
lol

Now I got to go about getting the beer!.
lol

Thank you guys and gals so much for all your help.
I wouldn't have been able to do it with you.

I'll up the url to you all when it's all said and done.

Thanks again!
Jaymz