Hi😀,
how can I fill a Select Box from a table in a database ??
Thank you very much
how can I fill a Select Box from a table in a database ??
Thank you very much
Hi yuki,
Sorry for the delay, I was away when you posted this.
1) Set up a DB Multi-Record Loader to get either one or two columns from the table. (Only one if you want the value and the text to be the same.) Use the WHERE box if you want to filter or or order the results e.g.
[attachment=1]21-05-2012 11-20-42.png[/attachment]
2) Set up the Dynamic Data tab in the drop-down (or checkbox group in this case) to match.
[attachment=0]21-05-2012 11-24-26.png[/attachment]
Bob
Sorry for the delay, I was away when you posted this.
1) Set up a DB Multi-Record Loader to get either one or two columns from the table. (Only one if you want the value and the text to be the same.) Use the WHERE box if you want to filter or or order the results e.g.
`active` = 1 ORDER BY `name`
[attachment=1]21-05-2012 11-20-42.png[/attachment]
2) Set up the Dynamic Data tab in the drop-down (or checkbox group in this case) to match.
[attachment=0]21-05-2012 11-24-26.png[/attachment]
Bob
This topic is locked and no more replies can be posted.