Nested while loops with incramentor

[Anon]

Hey gang, thanks for you patience with me.
I think I'm starting to catch on to it a little better now.

This is what I got so far.

$artist = mysql_query("SELECT music_artist from music WHERE music_artist LIKE 'A%'");
$album = mysql_query("SELECT music_album from music WHERE music_artist LIKE 'A%'");
$song = mysql_query("SELECT music_song from music WHERE music_artist LIKE 'A%'");

$x = 1;
$y = 1;
$z = 1;

while ($myrow=mysql_fetch_array($artist))
{

while ($myrow=mysql_fetch_array($album))
{

while $myrow=mysql_fetch_array($song))
{

printf('<param name=menu1i1ixiyiz value = "%s">, $myrow["music_song"]);
printf('<param name=menu1i1ixiyizurl value = "$URL/%s/%s/%s">, $myrow["music_artist"], $myrow["music_album"], $myrow["music_song"]);
$z = $z +1;

}

printf('<param name=menu1i1ixiy value = "%s">, $myrow["music_album"]);
$y = $y +1;

}

printf('<param name=menu1i1ix value = "%s">, $myrow["music_artist"]);
$x = $x +1;
}

Selecting the artist, the album, and the song from the artis starting with "A".
I'm loading all the songs, the albums then the artist into the applet that I have.

First menu is artist, second album, thrid is song. That's what I need tha counter for...I need to incrament for each of the menus.

I don't know how it's going to look in the forum but it's a little easier to view it in my text editor.

The reason I'm asking so many question is a.)I'm new at this and b.) there is no one else here that knows how to so it either.

So all your help is great.

Thanks,
Jaymz

[Anon]

having a quick glance through the code (although i'm not 100% sure what it's doing) i can spot a couple of things..

you're effectively trying to populate a 3d array of artists, their albums, and the songs in those albums, yes?

so far as i can see, you're not relating albums to their artists, nor songs to the albums that they are in.

if i can make a suggestion...
(note, this method is quite brute-force, but is fairly simple..)

select a list or artists starting with 'A'.
cycle throught them, echoing the relevant <param>, and for each one get a list of albums. then cycle through the albums (echoing as you go) and get a list of songs.

so you code might look roughly like...

$x=1;
$y=1;
$z=1;

#get a list of artists starting with 'A'
while (#each artist) {

#echo the artist param
#get a list of that artist's albums
while (#each album) {

  #echo tha album param.
  #get a list of the album's songs
  while (#each song){

     #echo the song param
     $z++;
  }
  $y++;

}
$x++;
}

[Anon]

This is what I'm trying to get by taking the data from the database.

<param name=menu1i1i1 value="Megadeth">
<param name=menu1i1i2 value="Metallica">

<param name=menu1i1i1i1 value="So Far So Go So What">
<param name=menu1i1i1i2 value="Countdown To Extinction">

<param name=menu1i1i2i1 value="Load">
<param name=menu1i1i2i2 value="Re-Load">

<param name=menu1i1i2i1i1 value="Memory Remains">
<param name=menu1i1i2i1i1url value="URL">

using the incrimenter to get the last 3 number values in the name tag and the select statement to get the artist and what not.

Hope that clears it up.

[Anon]

okay, so what do you want to know?

--
rad

[Anon]

Was wondering how to load the artist, their albums, and the songs from those albums from the database while incrimenting the param tags for the applet in the same process.

I think it should go like this...load the artist, the first artist album, and all the tracks from the album.
Then move to the second album if there is one.

The code that you replyed with last time looked good to me. But I wouln't really know for sure.

Thanks,
Jaymz