Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    26

    Unanswered: select help needed

    i have for each user permmision list of department
    i have departments of 1,2,3.....,50

    and the user have for example permission to :
    1,4,8,13,44

    i want to make a select that in each table the user will see only the things he has permission to !!!!!!!
    in the DB i write the permmision list like this :
    1,2,3,4,5,....(and so on)
    so how do i do it?
    thanks in advance
    epelg

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    168

    Re: select help needed

    As youe question is not that clear to me, I am guessing in this way.

    I think you should have the permissions like 01,02,03,....50..soon
    This will be helpfull in checking the permission in the list.
    you can use a query with like keywork
    eg: select * from department_table where user="username" and permission like '%$permission_no%'
    This may be a simple way.

    Rajesh

    Originally posted by pelegk2
    i have for each user permmision list of department
    i have departments of 1,2,3.....,50

    and the user have for example permission to :
    1,4,8,13,44

    i want to make a select that in each table the user will see only the things he has permission to !!!!!!!
    in the DB i write the permmision list like this :
    1,2,3,4,5,....(and so on)
    so how do i do it?
    thanks in advance
    epelg

  3. #3
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    Pelegk2, can you tell us exactly how your table are defined? Columns, primary/foreign keys, datatypes...all usefull information.

    With that information it will be easier to help you I think.

  4. #4
    Join Date
    Nov 2003
    Posts
    26

    never mind

    i didnt bul it ok
    now its working

  5. #5
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4

    Post

    That's nice. Another satisfied customer..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •