Originally posted by wanted420
ok now with a login site would i be better off making multi table?
One for username and pass?
One for security question and stuff of that sort?
One for person info like name email?
I would say this depends on how much info you would like to "store" in your db about each user. username, pwd, security questions, email ++ can surely be stored in the same table, but if you have a lot of(read xxx++) users and a lot of info about each user I guess I would preferred to use multiple tables. Multiple tables also gives you an issue about normalization of your db/tables, so if you don't have a good reason to choose multiple tables I would stick to one if it doesn't contain "repeating data" in any coloumns/fields.
If you want to have "standard data" like State, Country etc you would benefit in putting them in seperate tables with primary keys as foreign keys in your "member"-table.
