i have a MySQL table that contains a list of employees, their employee ID, and their supervisors name. On my page i have a dropdown menu populated with the supervisors name. When a person selects a supervisor, i want the next page to populate a list of all of their employees.
I originally had this set up with all of the employees names in the drop down, and the next page would populate info based on that person - and i was able to accomplish this one to one transfer, but I'm having trouble pulling back a one to many. I'm guessing i need to use a while loop, but am not sure how to accomplish this.
Can anyone help me out with this?