My problem is that my agency does not use MYSQL and their database for this particular project is an excel worksheet with some calculations being done. I could easily convert that to Access if need be.
This database has a list of users along with what level of system they are using and what level of system that actually need. (usually higher level). It then has a field that calculates their priority compared to the rest of the people that also need higher level systems. What I am trying to do is have a website that allows a user to search for their name and have it spit out their priority and a date as to when they will get changed.
Am I going about this all wrong with thinking that PHP can do this? I'm new to this type of work so I'm just seeing what it can or can't do. Maybe a perl script would work better, I don't know.
Any help would greatly appreciated.