[thelist] PHP Login from Evolt site.

Bowles, Mickey (RIC) Mickey.Bowles at SMNA.com
Tue Apr 10 15:27:57 CDT 2007


Agreed, just wanted to edit php as little as possible.  I think I will
give the run a join query to a privs table and see how far I can get.
Thanks! 

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Paul Bennett
Sent: Tuesday, April 10, 2007 4:25 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] PHP Login from Evolt site.

Hi Mickey,

This sounds ok, but it's a bit kludgy to have mixed data in a database
column delimited by an arbitrary character.

Perhaps a more extensible way would be to create a new table called
something like 'privileges' and map the user id to one or more privilege
entires?

Eg:

userId  |  privilege
-------------------------
123      |   9
345      |   1
345      |   4

This way you're not mixing and matching data in the users table and can
easily add privileges to an account without having to manipulate the
string.

Paul
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester and
archives of thelist go to: http://lists.evolt.org Workers of the Web,
evolt ! 
*****************************************************
The Contents of this e-mail and any attachments to it may contain confidential and/or legally privileged information. This information is only for use by the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or taking action based upon the information contained herein is strictly prohibited. If this e-mail was received in error, please notify the sender and return the documents immediately.

************************************************************




More information about the thelist mailing list