September 15th, 1999, 03:06 PM
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!
September 21st, 1999, 03:57 AM
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.