bobbyv102

Hello, As the post states I am fairly new to PHP. I am working on a database in MS SQL and what I am trying to do is use a PHP web page to pull data from it. The original script works to pull from one table, but now I need it to pull from 3 seperate tables. The database stores: 1. list of instructors = tblInstructors -Instructor id = eeid - instructor first name = fname - instructor last name = lname 2. list of Classes = tblSchedule -Course id = id - instructor name = fname - start date = Date -end date = EndDate 3. the survey responses = tblPostClassSurvey - 12 different survey question fields - survey id = id - course id = CourseID I need all the results from post class survey, but only of the name of the instructor which is stored in the php variable $instructor, and the date grouped by the date. Unfortunately I do not have the code I have used so far here at home, but a point in the right direction will help. I found several resources that used the join option and pulling my fields with dot notation (ie: tblSchedule.id) but that does not return anything. Any help woul dbe great help. Thanks Robert