1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    I'd like to find out how to query mysql to only show certain allowed fields. Forexample if personal info is entered into a database sot hat it can later be recalled via a php3 page but I would like to allow people to specify which info they do and don't want public. Perhaps they would like the organization to have thier address but only wants everyone else to ahve thier phone number that has access to view the list. Like a club roster or members page.

    Any advise of a pointer would be great!
  2. #2
  3. No Profile Picture
    Ulf Wendel
    Devshed Newbie (0 - 499 posts)
    The MySQL access privilige system works table based: http://www.tcx.se/Manual_chapter/manual_Privilege_system.html#Privilege_system . You will have to manage access rights for single table fields with help of your client application.


Similar Threads

  1. new to PHP-MySQL, deleting entries from database
    By gyppo100 in forum MySQL Help
    Replies: 4
    Last Post: February 1st, 2004, 11:37 AM
  2. Whois Servers and nomatch value
    By computer in forum Dev Shed Lounge
    Replies: 7
    Last Post: November 7th, 2003, 07:06 AM
  3. limiting entries per page - ms sql
    By fgeller in forum Java Help
    Replies: 0
    Last Post: August 28th, 2003, 11:51 AM
  4. Selecting duplicate entries using php with mysql?
    By strange1 in forum PHP Development
    Replies: 3
    Last Post: October 29th, 2002, 10:46 AM

IMN logo majestic logo threadwatch logo seochat tools logo