Displaying Table Data from Multiple rows

[Anon]

I am very new to php and mysql. We have a class assignment that is asking us to query four tables. The results of these tables creates a facultyid, courseid, semesterid, etc. We are to create a form where we can place a faculty id with all the classes they teach. Based on the query, each row will contain the faculty id, and one class they teach. How can I create a table where the faculty name and ID are in once, and all of their classes are listed below. Please help.

Thanks in advance.

[amcgrath]

At the simplest level,

Create a table for the faculty
FACULTY table:
f_id int4 Primary key
f_name varchar (person's name)

create a table for the courses
COURSE table:
c_id int4 primary key
c_name varchar(course name)

create a semester reference table
SEMESTER table:
s_id int4 primary key
s_name varchar(semester title)

Create a table grouping this info:
FACULTY_COURSE_GRP table:
f_id int4 foreign key to FACULTY table
c_id int4 foreign key to COURSE table
s_id int4 foregin key to SEMESTER table

An sql query grouping these would give you what you need.