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??? Quote Link to comment 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. Quote Link to comment 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.