I am developing a Music download system.
I thought to have two database tables.
One for songs and other one is for artists because some songs have two or more artists.
Then I created two tables call
Following are the structures of that tables.
Field Type Null Default id int(11) No name varchar(50) No size int(10) No lyrics varchar(35) No music varchar(35) No mastered int(35) No link varchar(355)No added timestamp No CURRENT_TIMESTAMP
Field Type Null Default id int(11) No sid int(10) No artist varchar(355) No
Now I want to display last 5 songs in the home page like following (song name - artist).
Pure Love - ARASH feat Helena
Hotel Califonia - The Eagles
I know I should use JOIN function. But my dear friends I have no idea how to use join function.
Can someone explain me with my database structure it will be great for me.