joining 2 tables together using php

[elainemurphy2]

I really need help with this!!

Have THREE database tables

COURSEINFO---

Field            Type

-----------------------     

CourseCode    varchar(10)   

Semester            int(1)

CourseYear    int(1)           

Day                    varchar(10)       

Time                    varchar(5)   

Subject            varchar(100)

 

WEEKTIMETABLE

---------------

UserId varchar(10)

day varchar(10)

Time varchar(10)

Subject varchar(100)

CourseCode varchar(10)

Semester int(1)

CourseYear(1)

 

Userinfo

---------------

UserId    int(11)               

firstname    varchar(15)           

lastname    varchar(20)           

username    varchar(15)           

password    varchar(20)           

email        varchar(20)       

coursecode varchar(10)   

courseyear    int(1)

 

the user enters in all their details at regestration then they login into the system. I have all the seperate course information in course info. The main aim of the program is to be able to make a unique timetable for each member. I want an php statment that transfers all the course info rows depending on what course and year the user picks during registration. However as there is no userid in courseinfo and this is the unique idenitfier for the timetable and is necessary to extract it how will i do this???

 

many thanks for your help!its very urgent!!