Dada78 Posted January 12, 2008 Share Posted January 12, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/85660-need-advice-on-databse-setup/ Share on other sites More sharing options...
fenway Posted January 12, 2008 Share Posted January 12, 2008 As long as no user will ever have 2 emails/passwords, you're right... but I would question the fromer. Quote Link to comment https://forums.phpfreaks.com/topic/85660-need-advice-on-databse-setup/#findComment-437289 Share on other sites More sharing options...
Dada78 Posted January 12, 2008 Author Share Posted January 12, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/85660-need-advice-on-databse-setup/#findComment-437509 Share on other sites More sharing options...
fenway Posted January 12, 2008 Share Posted January 12, 2008 No one will ever have a second e-mail? If so, one table it is. Quote Link to comment https://forums.phpfreaks.com/topic/85660-need-advice-on-databse-setup/#findComment-437521 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.