techiefreak05 Posted May 2, 2007 Share Posted May 2, 2007 about a year ago i started building my social network.. and soon my "users" table got filled with loads of different columns, and i started making more and more services which requires membership.. so i decided to create a universal account for all my services... but i dont want to hold all the info for every service in one database, because when people sign up for my universal account, theyd have to fil out a really big form and sign up for all my services at once, but i want them to just sign up for the account, and have access to my services, but theyd have to sign up for each service.... but theyd only have to register the site-sepecific information being that they already have registered their email, password, name, etc. so... what could i do? create one database that holds the universal account information, and create one databse for each service, and when users login to any service... it pulls their email and password out of the master account databse and checks it against the site-specfific database? im totally confused ..... sorry if this was really confusing ... if it was confusing... just think "Google Acounts" pretty much the exact same concept... you have one account that can access everything, but you have to sign up for each service Link to comment https://forums.phpfreaks.com/topic/49725-needs-some-advice/ Share on other sites More sharing options...
trq Posted May 2, 2007 Share Posted May 2, 2007 Database normalization techniques are what you need to learn, and here is a good introduction. Link to comment https://forums.phpfreaks.com/topic/49725-needs-some-advice/#findComment-243840 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.