Country select list

bobthebob01
Topic Author
Offline
Elite Member

11 years 3 months ago #32814 by bobthebob01

Country select list was created by bobthebob01

Hi,

By any chance, does anybody have the field elements to create a select list of countries?
I thought i would ask before creating such list with all countries.

Cheers

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

11 years 3 months ago #32821 by micker

Replied by micker on topic Country select list

no you need to it why your little hand

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

11 years 3 months ago #32838 by ggppdk

Replied by ggppdk on topic Country select list

You could create a DB table with readily available SQL here:
www.geekality.net/2011/08/21/cou ... for-mysql/

Then create a field of TYPE 'select' in SQL mode, with SQL query :

Code:

SELECT c.code AS value, c.name AS text FROM `countries` AS c

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.