Re: [PHP] list of countries
On 07/11/06, James Tu [EMAIL PROTECTED] wrote: Thanks everyone for the helpful links and suggestions! Any people here with access to a country list in Arabic or Chinese? http://www.foreignword.com/countries/Arabic.htm -robin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
On Tue, 2006-11-07 at 12:40 -0500, James Tu wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. Don't be lazy. And it's called marked up not muddled. Cheers, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | :: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
On Tuesday 07 November 2006 19:58, Robert Cummings wrote: On Tue, 2006-11-07 at 12:40 -0500, James Tu wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. Goto: http://27.org/isocountrylist/ -Stathis Don't be lazy. And it's called marked up not muddled. Cheers, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | | :: : | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
On Tue, November 7, 2006 11:40 am, James Tu wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. If you also have them in Chinese and Arabic that would be even better. If you Google for ISO Country Names Codes you'll find the standard list of countries and their 2-character codes. I suck that down every few months in a cron job and reset my country list in MySQL from it. I figure nobody can expect much better than that, given how seldom a country name changes or countries spring up out of nowhere or disappear. [tongue firmly planted in cheek, folks!] I'm sure somebody somewhere living in some country that does not make the ISO list will be mad at me someday, but I dunno what else I could do... I'm open to suggestions, however! And the Wikipedia list plus http://php.net/strip_tags might be better. -- Some people have a gift link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
Thanks everyone for the helpful links and suggestions! Any people here with access to a country list in Arabic or Chinese? -James -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] list of countries
ummm... i must be missing something how is asking for the list lazy??? -Original Message- From: Robert Cummings [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 9:59 AM To: James Tu Cc: PHP Subject: Re: [PHP] list of countries On Tue, 2006-11-07 at 12:40 -0500, James Tu wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. Don't be lazy. And it's called marked up not muddled. Cheers, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | :: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] list of countries
On Tue, 2006-11-07 at 12:12 -0800, bruce wrote: ummm... i must be missing something You're missing a capitalized 'i' at the beginning of your sentence :/ how is asking for the list lazy??? Because he saw a list, and then decided not to use it because it was muddled by HTML tags. That part is being lazy. At any rate, he asked for something unrelated to PHP. I'm sorry but PHP General isn't a data warehouse. Thank you for your concern, Rob. -- .. | InterJinn Application Framework - http://www.interjinn.com | :: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
A MySQL list would have been a better place for this. Then again Most people on the MySQL list would have known about http://dev.mysql.com/doc/world-setup/en/world-setup.html where as people on this are less likely to. On 11/7/06, James Tu [EMAIL PROTECTED] wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. If you also have them in Chinese and Arabic that would be even better. -James -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] list of countries
Sorry, maybe I should have posted on that list. My post was about the list rather than about using MySQL. My initial thought was that country lists would have been something that people in this forum would have encountered and was also hoping that some people here would have multi-language experience for country lists in other languages. Thanks to all that have pointed me in the right direction. -James On Nov 7, 2006, at 4:41 PM, Rory Browne wrote: A MySQL list would have been a better place for this. Then again Most people on the MySQL list would have known about http://dev.mysql.com/doc/world-setup/en/world-setup.html where as people on this are less likely to. On 11/7/06, James Tu [EMAIL PROTECTED] wrote: Does anyone have a list of countries in a handy format for importing into MySQL? I just really need a list. Wikipedia has a nice list, but it's muddled by HTML tags. If you also have them in Chinese and Arabic that would be even better. -James -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php