hansman Posted July 18, 2008 Share Posted July 18, 2008 Hello, i currently ran into major problems not thiking this scheme out and realized that its not possible, maybe someone could help me I have a table "ad" with fields like, State, County, Name, Username, Passoword, City. i have a drop down menu where a user can select their state, and a list of countys that have been entered for that state is listed. Once they click the county it shows all the names in the county. This works no problem. However, when i insert the "County" with mutiple names such as "county1, county2), i can use the explode() function but i need to insert them into the "County" field and make sure it is not a duplicate. I was thinking i would need to make another table with countys, states and then link it to the table "ad" by "name" any ideas how i can do this? Link to comment https://forums.phpfreaks.com/topic/115408-desnigning-the-database/ Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 Yes, you should definitely use another table for multiple countries... but I would also split the username/password from the address info. Link to comment https://forums.phpfreaks.com/topic/115408-desnigning-the-database/#findComment-597920 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.