I was wondering if someone could suggest the best layout for my MySQL database. I have a database whre people login with a username/password then I want is for a list of different options to be displayed to the user in a drop down menu. The options many change depending on the user, for example User 1 might have option a,b,c. And User 2 might have a,f,g,h,j,k.
So I was wondering if it might be best to have the username and password in 1 table. Then the username (again) and options in another table, and somehow link them. Would this work?
Rather than keeping the options in the same table, because the number of options, and option types change for each user.
Am I making sense? I'm not sure if I've explained it clearly enough. But any help would be much appreciated.
Cheers
Ben
So I was wondering if it might be best to have the username and password in 1 table. Then the username (again) and options in another table, and somehow link them. Would this work?
Rather than keeping the options in the same table, because the number of options, and option types change for each user.
Am I making sense? I'm not sure if I've explained it clearly enough. But any help would be much appreciated.
Cheers
Ben