[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?


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.


More information about the thelist mailing list