ccrevcypsys Posted November 16, 2007 Share Posted November 16, 2007 I am having a problem with my logic on creating these tables I want to have my home page so that people can add and remove sections that are displayed on that page. I also want them to be able to change the position of the sections. But i dont know how i should set up the db tables... So can someone help me? The idea i had for them is this (but im sure it wont work): ----portals---- ----myHome---- ----portalPos---- portal_id ---+ id id portal_name +---portal_id -----+ position customer_id +---portal_id Quote Link to comment https://forums.phpfreaks.com/topic/77662-i-am-having-a-problem-with-my-logic-on-creating-these-tables/ Share on other sites More sharing options...
axiom82 Posted November 17, 2007 Share Posted November 17, 2007 Portal ----- id html User ----- id first_name last_name User_Portal ----- user_id portal_id When the user is created or a new portal is created, the portal(s) will be added. The User_Portal table is a link between users and portals Quote Link to comment https://forums.phpfreaks.com/topic/77662-i-am-having-a-problem-with-my-logic-on-creating-these-tables/#findComment-393272 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.