Is it necessary that for the field to be enum in order for this script to work? If so I wasn't aware of that...
I tried to change this in the db and I get an error saying:
ALTER TABLE `applications` CHANGE `previous_employee` `previous_employee` ENUM NULL
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
I delete it this and tried re-creating it but I can't do this either, how can this be fixed?
BTW, if enum is not necessary I could change the values for anything else, the value sent to the db is not what matters, what matters is the html displayed on the page, thanks again.