Showing different layout depending on user's department?
Basically I am writing a startup script and have layout redirect depending on the user's department.
Ex: User has a department record called "Sales" and when he logs in, the startup script automatically finds out which department he or she is and redirects to the correct dashboard layout.
I thought of making a if-else statement by finding out the user department by matching the get(accountname) (since the accountname and "user full name" is the same) and the department name.
I know a bit of mysql and would like to do this: Select "x" from "table" where id="1"?
What would be the best way to do this? Or there are other solutions?
Any help much appreciated..