AddInput Options

Hello ,
is it possible to feed the array OPTIONS in AddInput dynamically? i would like to have a list of countries taken from the database but i don't know how.

"OPTIONS"=>array(
something like while(true){
feed the array;
}

),

etc...

You just need to build the options array in a variable before calling AddInput. It can be something like this:

$result=mysql_query($connection,"SELECT id, name FROM users WHERE
some_condition=true");

$options=array(""=>"Select an user");
while($row=mysql_fetch_row($result))
$options[$row[0]]=$row[1];

$form->AddInput(array(
"TYPE"=>"select",
"NAME"=>"users",
"ID"=>"users",
"VALUE"=>"",
"OPTIONS"=>$options,
"LABEL"=>"<u>U</u>ser",
"ACCESSKEY"=>"U"
));

thank you for your quick reply :
i tried what you said :

$result2=mysql_query("Select ID, COUNTRY from countries order by COUNTRY",$connexion2);
$options=array("Choose","Choose");
while($row2=mysql_fetch_row($result2)){
$options[$row2[0]]= $row2[1];
}

$subscription->AddInput(array(
"TYPE"=>"select",
"NAME"=>"country",
"ID"=>"country",
"VALUE"=>"Choose",
"SIZE"=>1,
"OPTIONS"=>$options,
"LABEL"=>"$_COUNTRY"
));


i get an error saying "country: it was not defined a valid input value" although my array options seems healthy:
print_r($options) gives me the following:
Array ( [0] => Choose [1] => ARUBA [2] => AFGHANISTAN [5] => ALBANIA [60] => ALGERIA [10] => AMERICAN SAMOA [6] => ANDORRA [3] => ANGOLA [4] => ANGUILLA [11] => ANTARCTICA [13] => ANTIGUA AND BARBUDA [8] => ARGENTINA [9] => ARMENIA [14] => AUSTRALIA [15] => AUSTRIA [16] => AZERBAIJAN [24] => BAHAMAS [23] => BAHRAIN [21] => BANGLADESH [31] => BARBADOS [26] => BELARUS [18] => BELGIUM [27] => BELIZE [19] => BENIN [28] => BERMUDA [33] => BHUTAN [29] => BOLIVIA [25] => BOSNIA &HERZEG. [35] => BOTSWANA [34] => BOUVET ISLAND [30] => BRAZIL [100] => BRIT. INDIAN OCEAN TERR. [32] => BRUNEI DARUSSALAM [22] => BULGARIA [20] => BURKINA FASO [17] => BURUNDI [113] => CAMBODIA [43] => CAMEROON [37] => CANADA [48] => CAPE VERDE [52] => CAYMAN ISLANDS [36] => CENTRAL AFRICAN REPUBLIC [204] => CHAD [40] => CHILE [41] => CHINA [51] => CHRISTMAS ISLAND [38] => COCOS (KEELING) ISLANDS [46] => COLOMBIA [47] => COMOROS [44] => CONGO [45] => COOK ISLANDS [49] => COSTA RICA [42] => COTE D'IVOIRE [95] => CROATIA (local name: Hrvatska) [50] => CUBA [53] => CYPRUS [54] => Czech Republic [58] => DENMARK [56] => DJIBOUTI [57] => DOMINICA [59] => DOMINICAN REPUBLIC [210] => EAST TIMOR [61] => ECUADOR [62] => EGYPT [191] => EL SALVADOR [84] => EQUATORIAL GUINEA [63] => ERITREA [66] => ESTONIA [67] => ETHIOPIA [70] => FALKLAND ISL.(MALVINAS) [72] => FAROE ISLANDS [69] => FIJI [68] => FINLAND [12] => FR. SOUTH. TERR. [71] => FRANCE [89] => FRENCH GUIANA [176] => FRENCH POLYNESIA [75] => GABON [82] => GAMBIA [77] => GEORGIA [55] => GERMANY [78] => GHANA [79] => GIBRALTAR [85] => GREECE [87] => GREENLAND [86] => GRENADA [81] => GUADELOUPE [90] => GUAM [88] => GUATEMALA [80] => GUINEA [83] => GUINEA-BISSAU [91] => GUYANA [96] => HAITI [93] => HEARD AND MC DON. ISL. [94] => HONDURAS [92] => HONG KONG [97] => HUNGARY [104] => ICELAND [99] => INDIA [98] => INDONESIA [102] => IRAN (ISLAMIC REPUBLIC OF) [103] => IRAQ [101] => IRELAND [105] => ISRAEL [106] => ITALY [107] => JAMAICA [109] => JAPAN [108] => JORDAN [110] => KAZAKHSTAN [111] => KENYA [114] => KIRIBATI [173] => KOREA, DEM. PEOPLE'S REP. [116] => KOREA, REPUBLIC OF [117] => KUWAIT [112] => KYRGYZSTAN [118] => LAO PEOPLE'S DEM.REP. [128] => LATVIA [119] => LEBANON [125] => LESOTHO [120] => LIBERIA [121] => LIBYAN ARAB JAMAHIRIYA [123] => LIECHTENSTEIN [126] => LITHUANIA [127] => LUXEMBOURG [129] => MACAU [137] => MACEDONIA, FORMER YU. [133] => MADAGASCAR [148] => MALAWI [149] => MALAYSIA [134] => MALDIVES [138] => MALI [139] => MALTA [136] => MARSHALL ISLANDS [146] => MARTINIQUE [144] => MAURITANIA [147] => MAURITIUS [150] => MAYOTTE [135] => MEXICO [73] => MICRONESIA, FED. ST. [132] => MOLDOVA, REPUBLIC OF [131] => MONACO [141] => MONGOLIA [145] => MONTSERRAT [130] => MOROCCO [143] => MOZAMBIQUE [140] => MYANMAR [151] => NAMIBIA [161] => NAURU [160] => NEPAL [158] => NETHERLANDS [152] => NEW CALEDONIA [162] => NEW ZEALAND [156] => NICARAGUA [153] => NIGER [155] => NIGERIA [157] => NIUE [154] => NORFOLK ISLAND [142] => NORTH. MARIANA ISLANDS [159] => NORWAY [163] => OMAN [164] => PAKISTAN [169] => PALAU [165] => PANAMA [170] => PAPUA NEW GUINEA [175] => PARAGUAY [167] => PERU [168] => PHILIPPINES [166] => PITCAIRN [171] => POLAND [174] => PORTUGAL [172] => PUERTO RICO [177] => QATAR [178] => REUNION [179] => ROMANIA [180] => RUSSIAN FEDERATION [181] => RWANDA [186] => S.GEORGIA AND THE S. SA. [115] => SAINT KITTS AND NEVIS [122] => SAINT LUCIA [232] => SAMOA [192] => SAN MARINO [195] => SAO TOME AND PRINCIPE [182] => SAUDI ARABIA [184] => SENEGAL [234] => SERBIA [201] => SEYCHELLES [190] => SIERRA LEONE [185] => SINGAPORE [197] => SLOVAKIA (Slovak Republic) [198] => SLOVENIA [189] => SOLOMON ISLANDS [193] => SOMALIA [235] => SOUTH AFRICA [65] => SPAIN [124] => SRI LANKA [225] => ST VINCENT & THE GRENADIN [187] => ST. HELENA [194] => ST. PIERRE AND MIQUELON [183] => SUDAN [196] => SURINAME [188] => SVALBARD & JAN MAYEN IS. [200] => SWAZILAND [199] => SWEDEN [39] => SWITZERLAND [202] => SYRIAN ARAB REPUBLIC [216] => TAIWAN [207] => TAJIKISTAN [217] => TANZANIA [206] => THAILAND [205] => TOGO [208] => TOKELAU [211] => TONGA [212] => TRINIDAD AND TOBAGO [213] => TUNISIA [214] => TURKEY [209] => TURKMENISTAN [203] => TURKS AND CAICOS IS. [215] => TUVALU [218] => UGANDA [219] => UKRAINE [7] => UNITED ARAB EMIRATES [76] => UNITED KINGDOM [222] => UNITED STATES [239] => UNKNOWN [221] => URUGUAY [223] => UZBEKISTAN [230] => VANUATU [224] => VATICAN [226] => VENEZUELA [229] => VIET NAM [227] => VIRGIN ISLANDS (BRITISH) [228] => VIRGIN ISLANDS (U.S.) [231] => WALLIS AND FUTUNA ISLANDS [64] => WESTERN SAHARA [233] => YEMEN [236] => ZAIRE [237] => ZAMBIA [238] => ZIMBABWE )


sorry if that is a stupid question but i discover your class today...
greetings from Germany
bernard

The VALUE attribute must be set to the index of the array of the option to be selected by the default. In your case it is '0'.

Thank you very much Manuel , now it works. Congratulation for your excellent work , this is benefiting many beings and thank you for your prompt support.
Bernard