Re: sharing records with assigned users

On Friday 27 August 2004 01:49, PHP Junkie wrote: > Coming back again to my problem.. > 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. You have a new table which has 2 columns: record_id, user_id Then: SELECT user_id FROM new_table WHERE record_id = whatever; -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* Cold hands, no gloves. */