SELECT code, name FROM table where year = " .$year." or year = ".$prevyear." and hide = 0 order by year desc
shoudl have worked, however it ended up to need some () in place to help with the and or statement
SELECT code, name FROM table where (year = " .$year." or year = ".$prevyear.") and hide = 0 order by year desc
Now 13STU (13 Study) is hidden so they can not select it more than once. :)
I have a meeting with the development team tomorrow at lunchtime. This I hope will go smooth and they will come back with a few modifications. If they don't come back with modification I know that I have done something wrong, as they should be asking about features or they have thought of something that I haven't.
One of the issues that we have is that the curriculum guide has been developed without listing the subject codes that I use throughout my program, these are five digit codes that will go back into the student management system. What we are going to do is print a list off.
Also required is a list of the hidden codes so we can hide the information. However we need a way of getting the deaf and richard centre students in.
A check of all the information that we have in the subjects table. The problems we have faced the most is around 12 science with two 12SCI subjects, and 12 technology apparel which has two cost listings in it.
It needs to be pointed out in the system that this is preliminary and not the final subject choice as they may not have the conditions of entry, there might be a clash, class sizes might be too small or too large. This statement is being written up tonight and will be implemented into the system tomorrow morning during the ICT PD development time.