Help for this page

Select Code to Download


  1. or download this
    users
    ------------
    ...
    ------------
    permissionTypeID
    subSectionID
    
  2. or download this
    SELECT     sb.subSectionID, pt.PermissionTypeID, p.Permission
    FROM       permissions p 
    ...
    INNER JOIN PermissionTypes pt ON p.permissionTypeID = pt.permissionTyp
    +eID
    INNER JOIN Section st         ON st.SectionID = sb.SectionID
    WHERE     (p.userID = $userID)