EdwardJ Posted October 29, 2008 Share Posted October 29, 2008 Hi, If building an application which requires several account types or profiles (admin, user, privileged user, etc). Should I use one single MySQL table with a field like account_type? or is it better to create multiple tables, one for each type of account, and then add users to each table, depending on the type of that user? Thanks a lot! Quote Link to comment Share on other sites More sharing options...
bobbinsbro Posted October 29, 2008 Share Posted October 29, 2008 if you're expecting to have a whole lot of users, you're query times would probably benefit from separate tables. otherwise, i would go with 1 table for the sake of simpler php code. Quote Link to comment Share on other sites More sharing options...
EdwardJ Posted October 29, 2008 Author Share Posted October 29, 2008 Gotcha! Thank you very much Quote Link to comment Share on other sites More sharing options...
bobbinsbro Posted October 29, 2008 Share Posted October 29, 2008 no problem. please set topic to solved. edit: sorry. didn't notice you did that already. :-\ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.