Jump to content

desnigning the database


hansman

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.