Help with relationship between 2 tables

[TCombs]

I have a table for logins and a table for addresses.

 

I'm using 1 form to create the username/password (which is being inserted into the "logins" database), and the persons name, address, etc. which is being inserted into the "addresses" database.

 

What do I need to do to make it so that when a user log's in to the site and make's it to the checkout page, that their address is tied to their username?

 

 

[dcro2]

Make a UNIQUE/AUTO_INCREMENT field called something like `user_id` to your `logins` table to identify your users uniquely. Then add a field to your `addresses` table which identifies the id of the user that the address belongs to.

 

Then you can call on the address easily:

SELECT address from addresses WHERE user_id = $id

[TCombs]

lol my apologies, yes, I meant table...not database.

 

dcro2...thanks for responding again!  You're a much trusted resource.

 

I'll give your advice a try and let you know how it turns out!

Thanks!

[TCombs]

DCRO2.....

 

Thanks again!  Everything is working now. 

 

You're an asset to these forums!

 

Thanks!

[dcro2]

Any time, ha. Glad to help.