Need advice on databse setup.

[Dada78]

Hello, I just need some quick advice on what you would do about this. I have a registration and login form that inserts and calls a table called users. The only columns are ID, email, password. Now I have this page below with this form that will submit to the database also.

 

http://www.mesquitechristmas.com/local/submit.php

 

The user will have to be registered and logged in in order to submit this form.

 

So this is my question. So I just add the columns to the users table with the email and password column, or should I create a new table for this information. If I make a new table then how would I be sure the info that is being submit is for the right person logged in. Hope that makes sense.

 

IMO, I think it would be better to add it to one table instead of having two tables because before this submit for the email and password are the only data that will be in this table.

 

-Thanks

[fenway]

As long as no user will ever have 2 emails/passwords, you're right... but I would question the fromer.

[Dada78]

No the users email and password will be unique. Only one email and password per user.

 

Can please explain what you mean about what you would question?

[fenway]

No one will ever have a second e-mail? If so, one table it is.