Re: Clarity needed

Yup, that's how I've done it before: tutors ------------- id tutorname courses ------------- id coursename xref_tutors_courses -------------------------------- tutor_id course_id But I've been known to do things goofy before. I'm curious to see how other people handle it. -TG ----- Original Message ----- From: tedd <tedd@sperling.com> To: <php-general@lists.php.net> Date: Wed, 4 Feb 2009 17:24:35 -0500 Subject: [PHP] Clarity needed > Hi gang: > > I need some fog removed. > > I have a problem where I have an unlimited number of tutors teaching > an unlimited number of courses. When I call upon a tutor, I want to > see all the courses they teach. > > In my old days, I would just set up a linked list of courses and > attach it to the tutor (another linked list). As a tutor adds > courses, I would just add the course to the end of the linked list. > If the tutor deletes a course, then I would remove it from the list > by changing a single pointer. If I needed a list of all the courses > the tutor taught, I would just run down the linked list pulling them > out as needed. > > But now I have to think in terms of records in a database. I'll > eventually figure it out, but what are your suggestions/solutions? > > I understand that I can have one record set up for each tutor, and > another record set up for each course, and then tie the two together > by another record like an assignment. That way I can have as many > assignments as I want tying courses to tutors. > > It that the way you guys would do it? > > Thanks, > > tedd