need help with mysql joins

a_dubDesign

Alright everybody, need some help with joins in mysql. Here's a run down of what I have. The number in song1-5 of ylw_weeks table is the id from the yls_songs table

table 1: 'yls_weeks':
id | week | song1 | song2 | song3 | song4 | song 5
-------------------------------------------------------------------------
1 | 9-18-2006 | 1 | 2 | 3 | 4 | 5
-------------------------------------------------------------------------
2 | 9-11-2006 | 1 | 2 | 3 | 4 | 5

table 2 'yls_songs':
id | name | lyrics | audio
----------------------------------------------------------------
1 | song1Name | ~~~~~ | pathToAudioFile
----------------------------------------------------------------
2 | song2Name | ~~~~~ | pathToAudioFile
and so on...

what I need to get is the weeks.week, and for week.song1-5 I need to get the name and audio from the songs table while still having the id.

I'm pretty sure I'm suppose to use a type of join, but I'm having issues getting it right, please help.

yy1124

a_dubDesign

yy1124

table 1: 'yls_weeks':
id | week
-------------------------------------------------------------------------
1 | 9-18-2006
-------------------------------------------------------------------------
2 | 9-11-2006
...

table 2 'yls_songs':
id | name | lyrics | audio
----------------------------------------------------------------
1 | song1Name | ~~~~~ | pathToAudioFile
----------------------------------------------------------------
2 | song2Name | ~~~~~ | pathToAudioFile
...

table3: yls_somename
row_id | week_id | songs_id
-----------------------------------------------
1 | 1 | 1
2 | 1 | 2
3 | 1 | 3
4 | 1 | 4
5 | 2 | 4
6 | 2 | 3

In this case you can have n number of songs for one and any different week.

query will be something like:
SELECT w.week, s.id, s.name, s.audio
FROM yls_weeks w, yls_songs s, yls_somename newtbl
WHERE newtbl.week_id = w.id
AND newtnbl.song_id = s.id

Just a suggestion.