I'm an old Access programmer trying to get something I use there frequently to work in PHP/MySQL.
I want to look up data in a database and then have that appear as the value in a select statement on an update form.
The issue is selecting a new supervisor for an employee. I use a random number to keep the supervisors straight, so I don't want someone having to remember that. When the staff member's record is accessed, I want the form to display the current information in the database, which can then be updated as needed. This works great just using text boxes but when I've tried to do it with Select statements it always reverts to the first record from the database, not the one for that person, forcing the data to be re-entered each time.
Any help will be appreciated.