I need to create a PHP script which can read an MS SQL database in order to authenticate users onto my website. Once they're authenticated, they get sent to their own personal log in page which allows them access to certain areas of the website. This needs to be dependant on whether or not they're in a specific user group, for instance, certain types of users get more access, basically just get sent to a different page.
Is this possible? I'm using an ODBC connection. All the serve side stuff to have the PHP and MS SQL server "talk" to each other has been done. I'm not very sure of the code as I've never done this before.
I apologise if I've posted in the wrong part of the forum, or if no one knows what I'm talking about.
Thanks in advance