MySQL Table links?

[Anon]

Hi all. I wish to do the following, but don't exactly know how to create it:

Customer Account Table:

Email
Password

Customer Access Table:

Email
Lastlogin
AccountStatus

What I want to do is when the customer logs into the site and they have no account, the information in the form updates the main Account table.

When the customer returns, the customer account table is checked to see if the user has an account. If email is found then it queries the access table to check the Account Status, returning true/false.

My questions:

1) Updating the customer account table is easy, but how do I make sure the customer account e-mail is the same in the customer access table?

2) When the customer returns, do I have to have two dbconnects/queries to see the different tables or can that be like 'linked/joined' somehow to review the data?

Thanks for any help given.

-- M

[geo115fr]

If I understand correctly, there is a 1:1 relationship between the two tables :

every customer is referenced in 1 row only of the Account table and in 1 row only of the Access table.

You should standardize your Database design by merging the 2 tables in 1. Access and Accounts represent the same entity.

So replies to your questions are straightforward with the new design...

[Anon]

Problem is when I do a query, I get an output that is nearly 6 columns in size... which what I want to avoid.

Is there another option?

-- M

[geo115fr]

Michael W wrote:

Problem is when I do a query, I get an output that is nearly 6 columns in size... which what I want to avoid.

Is there another option?

???
If you want to get less columns, just name the columns you ask for instead of asking for all with * :

select col1,col2,col3 from table