RE: [PHP] sharing records with assigned users

From: Date: Thu, 26 Aug 2004 17:53:55 +0000
Subject: RE: [PHP] sharing records with assigned users
Groups: php.general 
Request: Send a blank email to php-general+get-194821@lists.php.net to get a copy of this message
[snip] If, in the table I'm storing my records, I create a field which stores the Users allowed access to that particular record, then in case of multiple users, that single field will hold multiple user names... Which is a problem for me. And I might be applying a very wrong approach, logically, which is why I came forward for some assistance. [/snip] use a column for user levels (you'll only have a few) in the record and then add a column in the user table that designates what level that user is. RECORD TABLE Record ID UserLevels RecordFoo admin, user, read-only USER TABLE User Level Bob user Junkie admin Sue read-only

« previous php.general (#194821) next »