here’s bit of background.
I’ve recently took over the IT for a school. They are currently using a student grading report system a previous IT manager made in myphpadmin.
The problem with the report system is that a lot of subjects are shown, even for classes which don’t need it on the website. For example, class 1 (ages 5-6) will show subjects like woodworking?
The previous IT manager made an option to ‘hide a subject if blank’ used in the subject table however because there are columns with in columns (subject group and then subjects), if the table has a sub subject then it’s impossible for the hide feature to work.
I was wondering how I can make it so that subjects and sub subject can be hidden if left empty?
For example, English as subject group, I want to be able to hide the subject group (english), Writing and/or reading as subjects.
this is what is shown in the report.
I’m sorry if I sound dumb, Although I have a computer science background, I have never used phpmyadmin before this and I don’t really know where I could find the bespoke code if they did use that to hide the fields either. Kind of confused on what to do. Any pointers would be greatly appreciated. Thanks so much!