Jump to content

Archived

This topic is now archived and is closed to further replies.

WormTongue

linking two tables together

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.

Share this post


Link to post
Share on other sites

You want it to record when they logged in into the login data table and then switch over to the members table to execute member only stuff?

Share this post


Link to post
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?

Share this post


Link to post
Share on other sites

I\'m not sure. I\'d just use two queries (you don\'t have to change the first one, just make another).

Share this post


Link to post
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...

Share this post


Link to post
Share on other sites

×

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.