am developing a school management system, i gat this problem....i want enrolled students to move to new classes without doing it manually when new academic year enters anyone who can help plz.......
what if once all the records and results are done, the php system checks that all requirements are met and enrolls them in a new table called "2013 enrollements" So im saying that when you enter in my end of year results, such as maths english computers, each time a result is entered it checks to see if all the requirements are met, once all requirements met im enrolled in next year, and for next year perhaps its possilble to call the 2013 table automatically by getting the server year and working out which table to use. so this way you have accurate records for who was enrolled in previous years as well as soon as its 2013 you have the new enrollements updated already. Just my thoughts on how i would approach the situation.