Hi
I want to fill my drop down list from database table.
I saw few examples on this forum but it did not work out. I am using joomla 2.5.
I have a table name "Contact" with fields like id, name, address. And i have to fill drop down list for names by retrieving name from all records.
A dropdown in elements section. And DB Record Loader and show html in onLoad events section.
Provided field name as table column name "name". Dynamic Data option as "Yes"
DB Record Loader configuration i have
DB Field as "id". Table is selected appropriately.
Not sure about other options.
In Where statement i have provided Contact.id >=1, if i keep it empty i get sql error for where so provided above value.
Not sure about other options.
I am not sure about other options to set to fill drop down from database field.
Thanks,
I want to fill my drop down list from database table.
I saw few examples on this forum but it did not work out. I am using joomla 2.5.
I have a table name "Contact" with fields like id, name, address. And i have to fill drop down list for names by retrieving name from all records.
A dropdown in elements section. And DB Record Loader and show html in onLoad events section.
Provided field name as table column name "name". Dynamic Data option as "Yes"
DB Record Loader configuration i have
DB Field as "id". Table is selected appropriately.
Not sure about other options.
In Where statement i have provided Contact.id >=1, if i keep it empty i get sql error for where so provided above value.
Not sure about other options.
I am not sure about other options to set to fill drop down from database field.
Thanks,