Populating a dropdown menu via CMSB

Hi,

Sure, if you set up a section in the CMS to store a list of store names, you can use that list to dynamically populate a select box.

In this example, we're assuming that the section is called "stores".

First we select all the stores from the database. We also select which fields we want to use as the options values and labels. in this example, we use "num" and "title", but these can be changed to whatever you want:


<?php

$query = "SELECT * FROM `{$TABLE_PREFIX}stores`";
$stores = mysql_query_fetch_all_assoc($query);

$valueField = "num";
$labelField = "title";
?>

Then we output your select box:

<select id="Store Name" class="select480" name="Store Name">
<option value = "">Please Select...</option>

<?php foreach ($stores as $store): ?>
<option value = "<?php echo $store[$valueField];?>" <?php selectedIf($store[$valueField], @$_REQUEST['Store Name']);?>><?php echo $store[$labelField];?></option>
<?php endforeach ?>

</select>

Hope this helps

Hi Nigel,

Everything should work the same, the only difference is how the select box is populated. If you're just sending the value of the field in an email, you may not want to use "num" as the value field, consider a text based field like "title" instead.

Hope this helps

Thanks, Jason. I'll give this a try.