Hello frnds n experts
I m new in php mysql. i have a problem mainting artist table n song table
wht i want is to track artist so for that i create tables
Artist -[table]
artist_id
artist_name
artist_bio
Artist_role[Table]
role_id
role_name
Artist_role_link [Table]
role_id
artist_id
i want to add artist in song table
Song[table]
song_id
song_name
artist_id
Now the Problems
1.a song might have multiple artist name {How to allow users to select multiple artist n add them in mysql n retrive them when need}
2.How to track those artist { artist.php?id= }
I hope i m able to understand my problem
Please help
Thanks
