Please help with code I don't know where to begin!

can anyone help me?

I have a MySQL database as follows:

Software Table
software, software_logo, software_info, software_id

Author Table
author_id, activity_author, author_details

Subject Table
subject, science_content, subject_id

Activity Table
unique_id, activity_URL, curriculum_links, pedagogical_issues, answers, pupils_ict, teachers_ict, software_req, activity_level, author_id, subject_id

(software_id relates to pupils_ict, teachers_ict and software_req)

I would like to have a drop down menus that :
activity_author
activity_level
teachers_ict
pupils_ict
software_req

can be selected and the appropriate results will be displayed. however i have very little experience with code and am really struggling with this.

any help would be fantastic, please x