数据库下拉数组smarty


Database dropdown array smarty

我试图从数据库加载下拉选项,下拉本身看起来像这样:

    $mainarray = array(
 "Group" => array (
     "Mygroup" => "My Group is",
    "Type" => "dropdown",
    "Options" => GroupA,GroupB,#Here i would like to load Group names from DB
    "Description" => "",
    "Default" => "GroupA",
),

如何显示mysql的所有选项?大感谢

我会将您的选项设置为数组,然后像往常一样遍历它们

{foreach $options as $opt}
    <option value="{$opt}">{$opt}</option>
{/foreach}