trying to set up a students / courses system and hoping someone can help
because I'm a bit out of my depth. All and any help on this much appreciated.
I took this project on for a friend when it looked simple
and it's now getting beyond my skill set as a Front end designer !
So I have a table "myMembers" which has the member basics; name, id (a number), email, password etc.
I have a table "courses" which has course_ID, course_name and course_tutor.
I think this looks like a many-to-many scenario which is something I've never tackled and after
research I'm honestly more confused than when I started
There are six courses that members can sign up for.
I'm confused as to where to record which member has signed up to which course
and then how to query the "join" table (members_courses) to return, for instance, which courses
any particular member has signed up for, or which list of members has signed up to any particular course.
Very grateful for any help
Best wishes
Monty
