coldfiretech Posted September 7, 2008 Share Posted September 7, 2008 Hello, i am kinda new to database's and whatnot so im looking for some help / guidance. Im going to need like 7 tables due to the amount of fields for each section. I am trying figure how to make the id number relational across all tables. For instance the users id, login and password and email and whatnot will be stored in the users table. their id, first middle and last names and more will be in the personal table, their id, cellphone, homephone, and workphone will be stored in the contact table... and so forth... Ive got mysql admin and phpmyadmin installed so i should be ready to go. I have read a little bit about relational databases and understood most of it but im kinda stumped as to how i am really supposed to do this. Anyone??? Link to comment https://forums.phpfreaks.com/topic/123079-how-to-setup-my-database/ Share on other sites More sharing options...
fenway Posted September 8, 2008 Share Posted September 8, 2008 Simple store a reference to the user_id in each of the other tables. Link to comment https://forums.phpfreaks.com/topic/123079-how-to-setup-my-database/#findComment-636248 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.