Course display and hide logic

In the attached files you'll see [login to view URL] and course_display.php. Use the info in the database to search for a dummy course that I've created. The course should only be visible to user's in the tbl_course_members table where the view_content field is set to "Yes" On an entry to the [login to view URL] page where course_id and course_password are both correct (This logic has been sorted already), this project involves: Task 1 is to be executed directly underneath the line of code in line 160: echo "Cheso Ebox Course: $course_name "; Requirements: Check tbl_course_members to see if .$_SESSION['member_id'] matches applicant_id. If not, then insert into tbl_course_members (application_date, applicant_id, course_id), VALUES ( NOW(), $_SESSION['member_id'] , $course_id The page Below this point only displayed if tbl_course_members.view_content = "Yes". If tbl_course_members.view_content = "No" (which is the default value until changed by an authorised course creator), echo "You will be able to see the course details when you are approved. If and when your teacher approves you, you can refresh the page." Task 2: Hide and display logic. When a course_member who has view_content set to "Yes", enters the page, they should only see the 5 menu items on the left Namely: Instructions & resources Assignments Discussions Start New Discussion Course members The main column (See code: Main Column) should be blank. With the red headings I have in this column, 've tried to very clearly outline the logic of what shows depending on the values of the current user in the tbl_course_members (namely, whether view_content, post_content and creator are set to "Yes" or "No" Ie: If the user is not a creator (ie: [login to view URL] = "No"), but does have permission to view content (view_content = "Yes"), if they click on "Instructions & resources", they should see the content in between the big blue headings INSTRUCTIONS / RESOURCES and /INSTRUCTIONS / RESOURCES & also between the red headings (VISIBLE TO ALL where view_content = Yes) and (/VISIBLE TO ALL where view_content = Yes) ...if the same user then clicks on "Assignments" in the menu, they should see all contents between the big blue headers "ASSIGNMENTS" and "/ASSIGNMENTS" and between the red headings "(VISIBLE TO ALL where view_content = Yes) and (/VISIBLE TO ALL where view_content = Yes) If a user was a creator (ie: creator = Yes in tbl_course_members), and they clicked on "Assignments, they would ALSO see the form and data in between the red headings "(VISIBLE TO CREATOR ONLY) and (/VISIBLE TO CREATOR ONLY) Same logic applies for all the menu items. Any questions, just ask.