Jump to content

linking two tables together


WormTongue

Recommended Posts

Hello. I am very new to the whole mysql/m$sql and i was wondering what the easiest way is to link two tables together. Here is my situation: I have a membership system where users log on to check their account info and such. The log in info is stored in a different table than the rest of the data. So, what i want is when they log in, it points from the login table to the member table that has all of their account information. Is there any easy way to do this? Thanks for your help.

Link to comment
Share on other sites

yea, basically. If i understand where you are going, could i just change tables in my query statements to the member table? Is this is easiest way? What i was thinking was a way to link the two so that i don\'t have to change my query statements. I guess have the login table call the member table for me then i just have to access one table. Does this make sense?

Link to comment
Share on other sites

Ok, let me better clarify what i\'m thinking. We have a membership database with everybodies info in it. We want to put that online so members can update their info and such through the web. We are going to have them signup with their username being their e-mail address. I need to find a way to link their e-mail address with their info in the membership database.

 

Now we do have their e-mail in their account, but that information has not been updated in a long time since we never needed it until now. I don\'t want to call each person to get their correct e-mail address, so i would like to link their username(e-mail address) with their name and not by e-mail. The only problem is that i don\'t know how to do this...

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.