Edit Supervisor Lookup PHP Script

I need to have a PHP script edited to work with my MySQL database. The script will display Supervisors based on searching options for miles from a zipcode, last name, , first name, city, etc. It worked earlier but now the field names have changed. It must display the proper information based on "Home" or "Work"