[SOLVED] table structure - noob
Posted: Thu Aug 25, 2005 10:25 am
hey everyone-
keep in mind I have an extremely little grasp on php/MySQL. Here's my question. I've got a table with 6 or 7 columns in that holds member data (first name, last name, location, email, age...) and one of those columns is the person's username. When a person register's, I tell php to check the table for a username first to make sure no other member has that username. Now, because I don't reallly know what I am doing, I didn't set up an ID field or create any keys, etc. and I am just learning that might have been the right thing to do. So, can you give me any advice as to if my current method will have problems in the future (such as ineffecient queries) and if so, do you think it would be worth the time now, to try and us PHPAdmin to create an ID field, set some kind of key (after I read more) and set it to auto_incremement since there is only 30-50 records now. I'm just trying to make sure I'm not going to run into any problems down the road when if there is 5000 members or something. Any help/advice you could give me would be great.
Thanks for everything.
keep in mind I have an extremely little grasp on php/MySQL. Here's my question. I've got a table with 6 or 7 columns in that holds member data (first name, last name, location, email, age...) and one of those columns is the person's username. When a person register's, I tell php to check the table for a username first to make sure no other member has that username. Now, because I don't reallly know what I am doing, I didn't set up an ID field or create any keys, etc. and I am just learning that might have been the right thing to do. So, can you give me any advice as to if my current method will have problems in the future (such as ineffecient queries) and if so, do you think it would be worth the time now, to try and us PHPAdmin to create an ID field, set some kind of key (after I read more) and set it to auto_incremement since there is only 30-50 records now. I'm just trying to make sure I'm not going to run into any problems down the road when if there is 5000 members or something. Any help/advice you could give me would be great.
Thanks for everything.