Yep, 3 tables is the way to go! One for tutors, one for courses and
one to join them
Bastien
Sent from my iPod
On Feb 4, 2009, at 17:24, tedd <tedd@xxxxxxxxxxxx> wrote:
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
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
