[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