Never expected politics will get into a CB open source component...

Line #170 in the country list.txt

The word "Occupied" shouldn't be there.... this is not a political article but a country list for use in general sites. Besides there is no such country yet... ok they need a name fine, no problem. But no one occupied them. they have their own government. and that actually doesnt matter for the purpose of this list.......

That would be nice if someone fix the "bug" in the file that is available for download.

The attached SQL contains the entire list of 400+ countries recognized by the US and Canadian postal services.

The list has been formatted so that USA, Canada and UK are the top three values, then a seperator, then the remainder of the values.

Create your custom cb_country field.

Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.

Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.

All the best, Bill.

Post edited by: heymcd, at: 2006/07/09 12:39

Post edited by: heymcd, at: 2006/07/09 12:42

The attached SQL contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.

The list has been formatted so that US values are the top values, then a seperator, then the Canadian values.

Create your custom cb_state field.

Replace the 'YY' with your table pre-fix, replace the 'XX' with your fieldid.

Tested successfully using phpMyAdmin 2.8.1 against a mySQL 5.0.18 database.

All the best, Bill.

thanks !

Do you have a plain text version of these files ? i mean without the SQL ....

The attached plain text file contains the entire list of 400+ countries recognized by the US and Canadian postal services.

The attached plain text file contains the entire list of 70+ states, provinces and territories recognized by the US and Canadian postal services.