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! Link to comment https://forums.phpfreaks.com/topic/130630-solved-account-types-question/ 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. Link to comment https://forums.phpfreaks.com/topic/130630-solved-account-types-question/#findComment-677758 Share on other sites More sharing options...
EdwardJ Posted October 29, 2008 Author Share Posted October 29, 2008 Gotcha! Thank you very much Link to comment https://forums.phpfreaks.com/topic/130630-solved-account-types-question/#findComment-677768 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. :-\ Link to comment https://forums.phpfreaks.com/topic/130630-solved-account-types-question/#findComment-677770 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.