[thelist] PHP Login from Evolt site.
Paul Bennett
Paul.Bennett at wcc.govt.nz
Tue Apr 10 15:25:14 CDT 2007
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
More information about the thelist
mailing list