Code: Select all
$sql = "SELECT Usergroups.GroupName FROM Usergroup INNER JOIN User ON Usergroup.GroupID = User.GroupID";
//... mysql_select etc. ...
$rs = mysql_fetch_assoc(...);
//create an array of allowed usergroups (GroupName)
$ar_allowed = array("Employee", "Manager");
if (!in_array($rs['GroupName'], $ar_allowed)) {
//redirect
header(...);
}what is a more efficient way to do this?