[SOLVED] Im Stuck

[Northern Flame]

I created a page on my website that displays the artists of songs uploaded on my website,

and I want to make it so that when you click on the artist, it will display all of his/her songs

without me having to create a page for every artist and manually having to input their song titles.

I've already made it so that it displays the artists, but I have no idea how to make it display all

the songs that I have on my website that are by the artist that the user selects, I've tried so many things

and none seem to work 

heres the code that displays the artists, maybe this can help anyone who tries to help me,

 

while($row = mysql_fetch_array($sql)){
$artist = $row['name_artist'];
echo "<a href=\"".$_SERVER['PHP_SELF']."?artist=$artist\">".$row['name_artist']."</a><br /><br />";
}

 

ANY SUGGESTIONS WILL BE GREATLY APPRECIATED! 

[.Stealth]

Have you got another table for the songs?

 

so you would have:

 

artists with:

id

name

anything else

 

songs with:

id

name

anything else

 

artist_song_join with

artist_id

song_id

 

then you would use the artist_song_join to get the relevant songs from the database and display them on the artist's page.

[Northern Flame]

I have two tables,

mp3_artists

mp3_musics

 

mp3_artists:

 

- id_artist

- name_artist

 

mp3_musics

 

- id_music

- title_music

- playlist_music

- date_music

- active_music

 

I can create a table joining the two,

but how would I get the song titles to be displayed on

the artist page? How can I tell the script to display

the music of the artist that is clicked on?

Or do I create a seperate page, lets say "artist_music.php",

but still, how will I tell the script to only display the music from the

artist that was clicked on?

The only solution I came up with was to make a page for each artist

and manually put in the music names, but if theirs a way to do one of the first two

options I WOULD MUCH RATHER PREFER TO DO THAT!