Chud37 Posted July 14, 2010 Share Posted July 14, 2010 Ayup. Alright i have two tables: Users: ID, Username, Pass, AccessLevels 1 Bob 2323 1,2,3 Levels: ID, Name, Info, Page 1, Edit, The Edit Page, edit.php Sorry for the bad indenting I cant tab on here can I. Anyway, Originally the access levels were defined by 1,2,3,4, etc. I knew this was a bad way of doing it, but i thought i'd come back to it later. Well now is later. So how can i make this efficient? I want each user to have different access levels, and all the access levels are stored in a seperate table. There's gotta be a better way! ~Chud37 Quote Link to comment https://forums.phpfreaks.com/topic/207737-inner-join-or-something/ Share on other sites More sharing options...
Mchl Posted July 14, 2010 Share Posted July 14, 2010 Look up 'many-to-many relationship' Quote Link to comment https://forums.phpfreaks.com/topic/207737-inner-join-or-something/#findComment-1086000 Share on other sites More sharing options...
Chud37 Posted July 16, 2010 Author Share Posted July 16, 2010 I dont know how to do a many to many relationship, but i thinks i duns it. thanks for the tip! Quote Link to comment https://forums.phpfreaks.com/topic/207737-inner-join-or-something/#findComment-1086923 Share on other sites More sharing options...
Mchl Posted July 16, 2010 Share Posted July 16, 2010 That's why I told you to look it up Quote Link to comment https://forums.phpfreaks.com/topic/207737-inner-join-or-something/#findComment-1086938 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.