DELETED_5350

[fez]

I am not entirely sure I understand the first line of your post... What do you mean "sort" ?

If you are storing info in a mysql db for use with a website then the first thing I would do is drop the camel casing. Use lowercase with underscores to represent spaces. i.e. addr_1, addr_2.

This will avoid certain issues with lowercase and uppercase field / table names.

The structure you have is fine for simple storage of addresses.

 

[Stelly]

yer, I'm not sure what he means either... I guess you mean what fields do you need for your DB?

Stelly

 

[visibleman]

Have a look at http://bitboost.com/ref/international-address-formats/united-kingdom/ for address field formatting. This is the format I usually use for projects, although I also tend to include county (not necessarily needed) and country fields.

Just make sure fields are formatted correctly, especially postcodes which IIRC should be 7 characters long, opting-in spaces where needed eg: SG11WD becomes SG1 1DD etc.

 

[fez]

As long as you store all the information possible in separate fields then you will be fine. If you are passing this on to someone else then the most important thing will be the data being nicely formatted and complete. Its rarely a bad thing to have more data than you need, you can always ignore it.