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 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' 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! 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 Link to comment https://forums.phpfreaks.com/topic/207737-inner-join-or-something/#findComment-1086938 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.