• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Adding country select list

Adding country select list 16 years 4 months ago #1197

Hi all,
to use this code you will need to add a table to your Joomla database with a tool like phpMyAdmin or similar. I hope you can do that...
In attachment you will find a text file with the complete MySQL query. It will create a table called jos_form_countries with all the countries.

Once the table has been created, copy this code into your form (Script tab -> Script called on form display)
$database->setQuery("SELECT countries_name FROM #__form_countries");
$data = $database->loadObjectList();
 
foreach($fields as $i=>$field){
    if($field->name=='countryselect'){
        $string = array();
        if(!empty($data)){
            foreach($data as $data_row){
                $string[] = $data_row->countries_name.'|'.$data_row->countries_name ;
            }
        }
        $string = implode(',',$string);
        $fields[$i]->default_value = $string;
    }
}

In this code you will have to replace "countryselect" with the Field id of your select list.
Tell me if you have any problem.

Attachment MySQL_countries.zip not found

Attachments:
Last Edit: 14 years 2 months ago by octavian.
The administrator has disabled public write access.

Re:Adding country select list 16 years 2 months ago #1583

  • angelaus
  • angelaus's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
I did create the database and I did paste the script above to Script tab -> Script called on form display

then what?? I added a field (select field) called countryselect but I can not see coutries. I miss something :)
The administrator has disabled public write access.

Re:Adding country select list 16 years 2 months ago #1584

Hi angelaus,
it seems that you did everything right.
I tried again on my test site and it works.
Can you check if the table was succefully created?
- Table name is jos_form_countries
- Be sure that the field id (and not title) is called countryselect

What happen exactly, the select list is empty?
The administrator has disabled public write access.

Re:Adding country select list 16 years 2 months ago #1622

  • amims
  • amims's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
I just pasted the following code into my default value field of my \"country field\" and it worked really good.

<option value=\"\">Country...</option>
<option value=\"Afganistan\">Afghanistan</option>
<option value=\"Albania\">Albania</option>
<option value=\"Algeria\">Algeria</option>
<option value=\"American Samoa\">American Samoa</option>
<option value=\"Andorra\">Andorra</option>
<option value=\"Angola\">Angola</option>
<option value=\"Anguilla\">Anguilla</option>
<option value=\"Antigua & Barbuda\">Antigua & Barbuda</option>
<option value=\"Argentina\">Argentina</option>
<option value=\"Armenia\">Armenia</option>
<option value=\"Aruba\">Aruba</option>
<option value=\"Australia\">Australia</option>
<option value=\"Austria\">Austria</option>
<option value=\"Azerbaijan\">Azerbaijan</option>
<option value=\"Bahamas\">Bahamas</option>
<option value=\"Bahrain\">Bahrain</option>
<option value=\"Bangladesh\">Bangladesh</option>
<option value=\"Barbados\">Barbados</option>
<option value=\"Belarus\">Belarus</option>
<option value=\"Belgium\">Belgium</option>
<option value=\"Belize\">Belize</option>
<option value=\"Benin\">Benin</option>
<option value=\"Bermuda\">Bermuda</option>
<option value=\"Bhutan\">Bhutan</option>
<option value=\"Bolivia\">Bolivia</option>
<option value=\"Bonaire\">Bonaire</option>
<option value=\"Bosnia & Herzegovina\">Bosnia & Herzegovina</option>
<option value=\"Botswana\">Botswana</option>
<option value=\"Brazil\">Brazil</option>
<option value=\"British Indian Ocean Ter\">British Indian Ocean Ter</option>
<option value=\"Brunei\">Brunei</option>
<option value=\"Bulgaria\">Bulgaria</option>
<option value=\"Burkina Faso\">Burkina Faso</option>
<option value=\"Burundi\">Burundi</option>
<option value=\"Cambodia\">Cambodia</option>
<option value=\"Cameroon\">Cameroon</option>
<option value=\"Canada\">Canada</option>
<option value=\"Canary Islands\">Canary Islands</option>
<option value=\"Cape Verde\">Cape Verde</option>
<option value=\"Cayman Islands\">Cayman Islands</option>
<option value=\"Central African Republic\">Central African Republic</option>
<option value=\"Chad\">Chad</option>
<option value=\"Channel Islands\">Channel Islands</option>
<option value=\"Chile\">Chile</option>
<option value=\"China\">China</option>
<option value=\"Christmas Island\">Christmas Island</option>
<option value=\"Cocos Island\">Cocos Island</option>
<option value=\"Colombia\">Colombia</option>
<option value=\"Comoros\">Comoros</option>
<option value=\"Congo\">Congo</option>
<option value=\"Cook Islands\">Cook Islands</option>
<option value=\"Costa Rica\">Costa Rica</option>
<option value=\"Cote DIvoire\">Cote D'Ivoire</option>
<option value=\"Croatia\">Croatia</option>
<option value=\"Cuba\">Cuba</option>
<option value=\"Curaco\">Curacao</option>
<option value=\"Cyprus\">Cyprus</option>
<option value=\"Czech Republic\">Czech Republic</option>
<option value=\"Denmark\">Denmark</option>
<option value=\"Djibouti\">Djibouti</option>
<option value=\"Dominica\">Dominica</option>
<option value=\"Dominican Republic\">Dominican Republic</option>
<option value=\"East Timor\">East Timor</option>
<option value=\"Ecuador\">Ecuador</option>
<option value=\"Egypt\">Egypt</option>
<option value=\"El Salvador\">El Salvador</option>
<option value=\"Equatorial Guinea\">Equatorial Guinea</option>
<option value=\"Eritrea\">Eritrea</option>
<option value=\"Estonia\">Estonia</option>
<option value=\"Ethiopia\">Ethiopia</option>
<option value=\"Falkland Islands\">Falkland Islands</option>
<option value=\"Faroe Islands\">Faroe Islands</option>
<option value=\"Fiji\">Fiji</option>
<option value=\"Finland\">Finland</option>
<option value=\"France\">France</option>
<option value=\"French Guiana\">French Guiana</option>
<option value=\"French Polynesia\">French Polynesia</option>
<option value=\"French Southern Ter\">French Southern Ter</option>
<option value=\"Gabon\">Gabon</option>
<option value=\"Gambia\">Gambia</option>
<option value=\"Georgia\">Georgia</option>
<option value=\"Germany\">Germany</option>
<option value=\"Ghana\">Ghana</option>
<option value=\"Gibraltar\">Gibraltar</option>
<option value=\"Great Britain\">Great Britain</option>
<option value=\"Greece\">Greece</option>
<option value=\"Greenland\">Greenland</option>
<option value=\"Grenada\">Grenada</option>
<option value=\"Guadeloupe\">Guadeloupe</option>
<option value=\"Guam\">Guam</option>
<option value=\"Guatemala\">Guatemala</option>
<option value=\"Guinea\">Guinea</option>
<option value=\"Guyana\">Guyana</option>
<option value=\"Haiti\">Haiti</option>
<option value=\"Hawaii\">Hawaii</option>
<option value=\"Honduras\">Honduras</option>
<option value=\"Hong Kong\">Hong Kong</option>
<option value=\"Hungary\">Hungary</option>
<option value=\"Iceland\">Iceland</option>
<option value=\"India\">India</option>
<option value=\"Indonesia\">Indonesia</option>
<option value=\"Iran\">Iran</option>
<option value=\"Iraq\">Iraq</option>
<option value=\"Ireland\">Ireland</option>
<option value=\"Isle of Man\">Isle of Man</option>
<option value=\"Israel\">Israel</option>
<option value=\"Italy\">Italy</option>
<option value=\"Jamaica\">Jamaica</option>
<option value=\"Japan\">Japan</option>
<option value=\"Jordan\">Jordan</option>
<option value=\"Kazakhstan\">Kazakhstan</option>
<option value=\"Kenya\">Kenya</option>
<option value=\"Kiribati\">Kiribati</option>
<option value=\"Korea North\">Korea North</option>
<option value=\"Korea Sout\">Korea South</option>
<option value=\"Kuwait\">Kuwait</option>
<option value=\"Kyrgyzstan\">Kyrgyzstan</option>
<option value=\"Laos\">Laos</option>
<option value=\"Latvia\">Latvia</option>
<option value=\"Lebanon\">Lebanon</option>
<option value=\"Lesotho\">Lesotho</option>
<option value=\"Liberia\">Liberia</option>
<option value=\"Libya\">Libya</option>
<option value=\"Liechtenstein\">Liechtenstein</option>
<option value=\"Lithuania\">Lithuania</option>
<option value=\"Luxembourg\">Luxembourg</option>
<option value=\"Macau\">Macau</option>
<option value=\"Macedonia\">Macedonia</option>
<option value=\"Madagascar\">Madagascar</option>
<option value=\"Malaysia\">Malaysia</option>
<option value=\"Malawi\">Malawi</option>
<option value=\"Maldives\">Maldives</option>
<option value=\"Mali\">Mali</option>
<option value=\"Malta\">Malta</option>
<option value=\"Marshall Islands\">Marshall Islands</option>
<option value=\"Martinique\">Martinique</option>
<option value=\"Mauritania\">Mauritania</option>
<option value=\"Mauritius\">Mauritius</option>
<option value=\"Mayotte\">Mayotte</option>
<option value=\"Mexico\">Mexico</option>
<option value=\"Midway Islands\">Midway Islands</option>
<option value=\"Moldova\">Moldova</option>
<option value=\"Monaco\">Monaco</option>
<option value=\"Mongolia\">Mongolia</option>
<option value=\"Montserrat\">Montserrat</option>
<option value=\"Morocco\">Morocco</option>
<option value=\"Mozambique\">Mozambique</option>
<option value=\"Myanmar\">Myanmar</option>
<option value=\"Nambia\">Nambia</option>
<option value=\"Nauru\">Nauru</option>
<option value=\"Nepal\">Nepal</option>
<option value=\"Netherland Antilles\">Netherland Antilles</option>
<option value=\"Netherlands\">Netherlands</option>
<option value=\"Nevis\">Nevis</option>
<option value=\"New Caledonia\">New Caledonia</option>
<option value=\"New Zealand\">New Zealand</option>
<option value=\"Nicaragua\">Nicaragua</option>
<option value=\"Niger\">Niger</option>
<option value=\"Nigeria\">Nigeria</option>
<option value=\"Niue\">Niue</option>
<option value=\"Norfolk Island\">Norfolk Island</option>
<option value=\"Norway\">Norway</option>
<option value=\"Oman\">Oman</option>
<option value=\"Pakistan\">Pakistan</option>
<option value=\"Palau Island\">Palau Island</option>
<option value=\"Palestine\">Palestine</option>
<option value=\"Panama\">Panama</option>
<option value=\"Papua New Guinea\">Papua New Guinea</option>
<option value=\"Paraguay\">Paraguay</option>
<option value=\"Peru\">Peru</option>
<option value=\"Phillipines\">Philippines</option>
<option value=\"Pitcairn Island\">Pitcairn Island</option>
<option value=\"Poland\">Poland</option>
<option value=\"Portugal\">Portugal</option>
<option value=\"Puerto Rico\">Puerto Rico</option>
<option value=\"Qatar\">Qatar</option>
<option value=\"Reunion\">Reunion</option>
<option value=\"Romania\">Romania</option>
<option value=\"Russia\">Russia</option>
<option value=\"Rwanda\">Rwanda</option>
<option value=\"St Barthelemy\">St Barthelemy</option>
<option value=\"St Eustatius\">St Eustatius</option>
<option value=\"St Helena\">St Helena</option>
<option value=\"St Kitts-Nevis\">St Kitts-Nevis</option>
<option value=\"St Lucia\">St Lucia</option>
<option value=\"St Maarten\">St Maarten</option>
<option value=\"St Pierre & Miquelon\">St Pierre & Miquelon</option>
<option value=\"St Vincent & Grenadines\">St Vincent & Grenadines</option>
<option value=\"Saipan\">Saipan</option>
<option value=\"Samoa\">Samoa</option>
<option value=\"Samoa American\">Samoa American</option>
<option value=\"San Marino\">San Marino</option>
<option value=\"Sao Tome & Principe\">Sao Tome & Principe</option>
<option value=\"Saudi Arabia\">Saudi Arabia</option>
<option value=\"Senegal\">Senegal</option>
<option value=\"Seychelles\">Seychelles</option>
<option value=\"Serbia & Montenegro\">Serbia & Montenegro</option>
<option value=\"Sierra Leone\">Sierra Leone</option>
<option value=\"Singapore\">Singapore</option>
<option value=\"Slovakia\">Slovakia</option>
<option value=\"Slovenia\">Slovenia</option>
<option value=\"Solomon Islands\">Solomon Islands</option>
<option value=\"Somalia\">Somalia</option>
<option value=\"South Africa\">South Africa</option>
<option value=\"Spain\">Spain</option>
<option value=\"Sri Lanka\">Sri Lanka</option>
<option value=\"Sudan\">Sudan</option>
<option value=\"Suriname\">Suriname</option>
<option value=\"Swaziland\">Swaziland</option>
<option value=\"Sweden\">Sweden</option>
<option value=\"Switzerland\">Switzerland</option>
<option value=\"Syria\">Syria</option>
<option value=\"Tahiti\">Tahiti</option>
<option value=\"Taiwan\">Taiwan</option>
<option value=\"Tajikistan\">Tajikistan</option>
<option value=\"Tanzania\">Tanzania</option>
<option value=\"Thailand\">Thailand</option>
<option value=\"Togo\">Togo</option>
<option value=\"Tokelau\">Tokelau</option>
<option value=\"Tonga\">Tonga</option>
<option value=\"Trinidad & Tobago\">Trinidad & Tobago</option>
<option value=\"Tunisia\">Tunisia</option>
<option value=\"Turkey\">Turkey</option>
<option value=\"Turkmenistan\">Turkmenistan</option>
<option value=\"Turks & Caicos Is\">Turks & Caicos Is</option>
<option value=\"Tuvalu\">Tuvalu</option>
<option value=\"Uganda\">Uganda</option>
<option value=\"Ukraine\">Ukraine</option>
<option value=\"United Arab Erimates\">United Arab Emirates</option>
<option value=\"United Kingdom\">United Kingdom</option>
<option value=\"United States of America\">United States of America</option>
<option value=\"Uraguay\">Uruguay</option>
<option value=\"Uzbekistan\">Uzbekistan</option>
<option value=\"Vanuatu\">Vanuatu</option>
<option value=\"Vatican City State\">Vatican City State</option>
<option value=\"Venezuela\">Venezuela</option>
<option value=\"Vietnam\">Vietnam</option>
<option value=\"Virgin Islands (Brit)\">Virgin Islands (Brit)</option>
<option value=\"Virgin Islands (USA)\">Virgin Islands (USA)</option>
<option value=\"Wake Island\">Wake Island</option>
<option value=\"Wallis & Futana Is\">Wallis & Futana Is</option>
<option value=\"Yemen\">Yemen</option>
<option value=\"Zaire\">Zaire</option>
<option value=\"Zambia\">Zambia</option>
<option value=\"Zimbabwe\">Zimbabwe</option>
The administrator has disabled public write access.

Re:Adding country select list 16 years 1 month ago #1922

  • jasonjia
  • jasonjia's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
I tried this code and it works perfect.

The only thing is that if you paste the code, then click add field, and when you finished adding the field, the code you pasted will be gone. It happens to me and I have to re-paste the code, and it works
The administrator has disabled public write access.

Re:Adding country select list 15 years 11 months ago #2800

  • Rafi
  • Rafi's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
It dose not work for me but this does :)

Ireland|Ireland,
United Kingdom|United Kingdom,
Malaysia|Malaysia,
Singapore|Singapore,
South Africa|South Africa,
|
,
Afganistan|Afghanistan,
Albania|Albania,
Algeria|Algeria,
American Samoa|American Samoa,
Andorra|Andorra,
Angola|Angola,
Anguilla|Anguilla,
Antigua & Barbuda|Antigua & Barbuda,
Argentina|Argentina,
Armenia|Armenia,
Aruba|Aruba,
Australia|Australia,
Austria|Austria,
Azerbaijan|Azerbaijan,
Bahamas|Bahamas,
Bahrain|Bahrain,
Bangladesh|Bangladesh,
Barbados|Barbados,
Belarus|Belarus,
Belgium|Belgium,
Belize|Belize,
Benin|Benin,
Bermuda|Bermuda,
Bhutan|Bhutan,
Bolivia|Bolivia,
Bonaire|Bonaire,
Bosnia & Herzegovina|Bosnia & Herzegovina,
Botswana|Botswana,
Brazil|Brazil,
British Indian Ocean Ter|British Indian Ocean Ter,
Brunei|Brunei,
Bulgaria|Bulgaria,
Burkina Faso|Burkina Faso,
Burundi|Burundi,
Cambodia|Cambodia,
Cameroon|Cameroon,
Canada|Canada,
Canary Islands|Canary Islands,
Cape Verde|Cape Verde,
Cayman Islands|Cayman Islands,
Central African Republic|Central African Republic,
Chad|Chad,
Channel Islands|Channel Islands,
Chile|Chile,
China|China,
Christmas Island|Christmas Island,
Cocos Island|Cocos Island,
Colombia|Colombia,
Comoros|Comoros,
Congo|Congo,
Cook Islands|Cook Islands,
Costa Rica|Costa Rica,
Cote DIvoire|Cote D'Ivoire,
Croatia|Croatia,
Cuba|Cuba,
Curaco|Curacao,
Cyprus|Cyprus,
Czech Republic|Czech Republic,
Denmark|Denmark,
Djibouti|Djibouti,
Dominica|Dominica,
Dominican Republic|Dominican Republic,
East Timor|East Timor,
Ecuador|Ecuador,
Egypt|Egypt,
El Salvador|El Salvador,
Equatorial Guinea|Equatorial Guinea,
Eritrea|Eritrea,
Estonia|Estonia,
Ethiopia|Ethiopia,
Falkland Islands|Falkland Islands,
Faroe Islands|Faroe Islands,
Fiji|Fiji,
Finland|Finland,
France|France,
French Guiana|French Guiana,
French Polynesia|French Polynesia,
French Southern Ter|French Southern Ter,
Gabon|Gabon,
Gambia|Gambia,
Georgia|Georgia,
Germany|Germany,
Ghana|Ghana,
Gibraltar|Gibraltar,
Great Britain|Great Britain,
Greece|Greece,
Greenland|Greenland,
Grenada|Grenada,
Guadeloupe|Guadeloupe,
Guam|Guam,
Guatemala|Guatemala,
Guinea|Guinea,
Guyana|Guyana,
Haiti|Haiti,
Hawaii|Hawaii,
Honduras|Honduras,
Hong Kong|Hong Kong,
Hungary|Hungary,
Iceland|Iceland,
India|India,
Indonesia|Indonesia,
Iran|Iran,
Iraq|Iraq,
Ireland|Ireland,
Isle of Man|Isle of Man,
Israel|Israel,
Italy|Italy,
Jamaica|Jamaica,
Japan|Japan,
Jordan|Jordan,
Kazakhstan|Kazakhstan,
Kenya|Kenya,
Kiribati|Kiribati,
Korea North|Korea North,
Korea Sout|Korea South,
Kuwait|Kuwait,
Kyrgyzstan|Kyrgyzstan,
Laos|Laos,
Latvia|Latvia,
Lebanon|Lebanon,
Lesotho|Lesotho,
Liberia|Liberia,
Libya|Libya,
Liechtenstein|Liechtenstein,
Lithuania|Lithuania,
Luxembourg|Luxembourg,
Macau|Macau,
Macedonia|Macedonia,
Madagascar|Madagascar,
Malaysia|Malaysia,
Malawi|Malawi,
Maldives|Maldives,
Mali|Mali,
Malta|Malta,
Marshall Islands|Marshall Islands,
Martinique|Martinique,
Mauritania|Mauritania,
Mauritius|Mauritius,
Mayotte|Mayotte,
Mexico|Mexico,
Midway Islands|Midway Islands,
Moldova|Moldova,
Monaco|Monaco,
Mongolia|Mongolia,
Montserrat|Montserrat,
Morocco|Morocco,
Mozambique|Mozambique,
Myanmar|Myanmar,
Nambia|Nambia,
Nauru|Nauru,
Nepal|Nepal,
Netherland Antilles|Netherland Antilles,
Netherlands|Netherlands,
Nevis|Nevis,
New Caledonia|New Caledonia,
New Zealand|New Zealand,
Nicaragua|Nicaragua,
Niger|Niger,
Nigeria|Nigeria,
Niue|Niue,
Norfolk Island|Norfolk Island,
Norway|Norway,
Oman|Oman,
Pakistan|Pakistan,
Palau Island|Palau Island,
Palestine|Palestine,
Panama|Panama,
Papua New Guinea|Papua New Guinea,
Paraguay|Paraguay,
Peru|Peru,
Phillipines|Philippines,
Pitcairn Island|Pitcairn Island,
Poland|Poland,
Portugal|Portugal,
Puerto Rico|Puerto Rico,
Qatar|Qatar,
Reunion|Reunion,
Romania|Romania,
Russia|Russia,
Rwanda|Rwanda,
St Barthelemy|St Barthelemy,
St Eustatius|St Eustatius,
St Helena|St Helena,
St Kitts-Nevis|St Kitts-Nevis,
St Lucia|St Lucia,
St Maarten|St Maarten,
St Pierre & Miquelon|St Pierre & Miquelon,
St Vincent & Grenadines|St Vincent & Grenadines,
Saipan|Saipan,
Samoa|Samoa,
Samoa American|Samoa American,
San Marino|San Marino,
Sao Tome & Principe|Sao Tome & Principe,
Saudi Arabia|Saudi Arabia,
Senegal|Senegal,
Seychelles|Seychelles,
Serbia & Montenegro|Serbia & Montenegro,
Sierra Leone|Sierra Leone,
Singapore|Singapore,
Slovakia|Slovakia,
Slovenia|Slovenia,
Solomon Islands|Solomon Islands,
Somalia|Somalia,
South Africa|South Africa,
Spain|Spain,
Sri Lanka|Sri Lanka,
Sudan|Sudan,
Suriname|Suriname,
Swaziland|Swaziland,
Sweden|Sweden,
Switzerland|Switzerland,
Syria|Syria,
Tahiti|Tahiti,
Taiwan|Taiwan,
Tajikistan|Tajikistan,
Tanzania|Tanzania,
Thailand|Thailand,
Togo|Togo,
Tokelau|Tokelau,
Tonga|Tonga,
Trinidad & Tobago|Trinidad & Tobago,
Tunisia|Tunisia,
Turkey|Turkey,
Turkmenistan|Turkmenistan,
Turks & Caicos Is|Turks & Caicos Is,
Tuvalu|Tuvalu,
Uganda|Uganda,
Ukraine|Ukraine,
United Arab Erimates|United Arab Emirates,
United Kingdom|United Kingdom,
United States of America|United States of America,
Uraguay|Uruguay,
Uzbekistan|Uzbekistan,
Vanuatu|Vanuatu,
Vatican City State|Vatican City State,
Venezuela|Venezuela,
Vietnam|Vietnam,
Virgin Islands (Brit)|Virgin Islands (Brit),
Virgin Islands (USA)|Virgin Islands (USA),
Wake Island|Wake Island,
Wallis & Futana Is|Wallis & Futana Is,
Yemen|Yemen,
Zaire|Zaire,
Zambia|Zambia,
Zimbabwe|Zimbabwe
The administrator has disabled public write access.

Re:Adding country select list 15 years 8 months ago #3736

  • haboyes
  • haboyes's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
The code listed in the first posting in this thread does not work in RSform!Pro. To achieve the same result in RSform!Pro use the following code:
 
//<code>
$q="SELECT `iso`,`countries_name` FROM `jos_form_countries`";
$rez=mysql_query($q) or die(mysql_error());
$out='';
while($r=mysql_fetch_array($rez)) $out.=$r[0].'|'.$r[1]."\\n";
return $out;
//</code>
 

This creates an option list of countries (using the database table contained in the attachment to the first post). The option list will display the country name e.g. Afghanistan and then stores the ISO code for that country, in this example AF.
Last Edit: 14 years 2 months ago by octavian.
The administrator has disabled public write access.

Re:Adding country select list 15 years 8 months ago #3819

  • dragonjc
  • dragonjc's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 151
Hi, i have found this solution before but their is just a problem with them on \"\n\" :
after save, \"\n\" become => \"n\" and script doesn't fonctionned.
I it is, don't forget addcslahes with n.
Component RS SHow Form in build
The administrator has disabled public write access.

Re:Adding country select list 15 years 8 months ago #3820

  • dragonjc
  • dragonjc's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 151
Hi, i have found this solution before but their is just a problem with them on \"\n\" :
after save, \"\n\" become => \"n\" and script doesn't fonctionned.
I it is, don't forget addcslahes with n.
Component RS SHow Form in build
The administrator has disabled public write access.

Re:Adding country select list 15 years 6 months ago #4541

Has anyone come up with a solution to this problem yet? I simply get \"Table 'joomla156.jos_form_countries' doesn't exist\" when the script runs but the database is quite definitely there.
RSform!Pro 1.1.0 rev 17
XAMPP for Windows Version 1.6.7!
PHP Version 5.2.4
The administrator has disabled public write access.

Re:Adding country select list 15 years 6 months ago #4844

Terence,

To be able to use the code sent by Haboyes you need the Mapping plugin.

Did you check that it is correctly installed?
The administrator has disabled public write access.

Re:Adding country select list 14 years 1 month ago #9799

  • dacworks
  • dacworks's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
HAs anyone got a working example of this
Seems it would be the perfect way to prefil a form with data from mysql
Neither documented script works for me

Any help appreciated
The administrator has disabled public write access.

Re:Adding country select list 12 years 11 months ago #13445

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
|Select...
Afganistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antigua & Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bonaire
Bosnia & Herzegovina
Botswana
Brazil
British Indian Ocean Ter
Brunei
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Canary Islands
Cape Verde
Cayman Islands
Central African Republic
Chad
Channel Islands
Chile
China
Christmas Island
Cocos Island
Colombia
Comoros
Congo
Cook Islands
Costa Rica
Cote DIvoire
Croatia
Cuba
Curaco
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
French Southern Ter
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Great Britain
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guyana
Haiti
Hawaii
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Isle of Man
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Korea North
Korea Sout
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malaysia
Malawi
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Midway Islands
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Nambia
Nauru
Nepal
Netherland Antilles
Netherlands
Nevis
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Oman
Pakistan
Palau Island
Palestine
Panama
Papua New Guinea
Paraguay
Peru
Phillipines
Pitcairn Island
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russia
Rwanda
St Barthelemy
St Eustatius
St Helena
St Kitts-Nevis
St Lucia
St Maarten
St Pierre & Miquelon
St Vincent & Grenadines
Saipan
Samoa
Samoa American
San Marino
Sao Tome & Principe
Saudi Arabia
Senegal
Seychelles
Serbia & Montenegro
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Tahiti
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tokelau
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Turks & Caicos Is
Tuvalu
Uganda
Ukraine
United Arab Erimates
United Kingdom
United States of America
Uraguay
Uzbekistan
Vanuatu
Vatican City State
Venezuela
Vietnam
Virgin Islands (Brit)
Virgin Islands (USA)
Wake Island
Wallis & Futana Is
Yemen
Zaire
Zambia
Zimbabwe
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Re:Adding country select list 11 years 5 months ago #19630

  • dom2012
  • dom2012's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 14
  • Thank you received: 2
There's a few typos in that list. Here's a corrected version (to the best of my ability).

|Select...)
Afghanistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antigua & Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bonaire
Bosnia & Herzegovina
Botswana
Brazil
British Indian Ocean Territory
Brunei
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Canary Islands
Cape Verde
Cayman Islands
Central African Republic
Chad
Channel Islands
Chile
China
Christmas Island
Cocos Island
Colombia
Comoros
Congo
Cook Islands
Costa Rica
Cote Divoire
Croatia
Cuba
Curaco
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
French Southern Territory
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guinea
Guyana
Haiti
Hawaii
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Iraq
Ireland
Isle of Man
Israel
Italy
Jamaica
Japan
Jordan
Kazakhstan
Kenya
Kiribati
Korea North
Korea South
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malaysia
Malawi
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Midway Islands
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Nambia
Nauru
Nepal
Netherland Antilles
Netherlands
Nevis
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Oman
Pakistan
Palau Island
Palestine
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn Island
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russia
Rwanda
St Barthelemy
St Eustatius
St Helena
St Kitts-Nevis
St Lucia
St Maarten
St Pierre & Miquelon
St Vincent & Grenadines
Saipan
Samoa
Samoa American
San Marino
Sao Tome & Principe
Saudi Arabia
Senegal
Seychelles
Serbia & Montenegro
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
Spain
Sri Lanka
Sudan
Suriname
Swaziland
Sweden
Switzerland
Syria
Tahiti
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tokelau
Tonga
Trinidad & Tobago
Tunisia
Turkey
Turkmenistan
Turks & Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States of America
Uruguay
Uzbekistan
Vanuatu
Vatican City State
Venezuela
Vietnam
Virgin Islands (Britain)
Virgin Islands (USA)
Wake Island
Wallis & Futana Is
Yemen
Zaire
Zambia
Zimbabwe
The administrator has disabled public write access.
The following user(s) said Thank You: accessvirus, midwesternholdingscorp
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!