Dynamically populate a drop down menu from one of my fields and remove duplicates

Hi Jerry,

Are these labels coming from a list field? If they are then this might be an easier way of doing it:

 <select name="profession" class="textbox" id="profession">
   <option value= "">Select Publication Type</option>
   <?php foreach(getListOptions('table_name_here', 'mobility_aid_category') as $value => $name): ?>
      <option value="<?php echo $value; ?>"><?php echo $name; ?></option>
   <?php endforeach; ?>
</select>

If you replace table_name_here with the table name that contains the list field you want to use.

getListOptions is a CMS Builder function that should automatically generate an array of drop down options for you.

Thanks

Greg

Hi Greg,

Thanks for this. It certainly simplified the code required.

I've modified the code you suggested to eliminate those categories that do not have records associated with them, but can't seem to get rid of the duplicate entries in the list when there is more than one record in that category.

IE If there are 3 record in one of the categories that category will appear in the pull doen options list three times.

Here's the code that I'm using:

 <select name="mobility_aid_category" >
   <option value= "">Choose The Category To Display And Click/Tap The Search Button</option>
   <?php foreach(getListOptions('mobility_aids', 'mobility_aid_category') as $value => $name): ?>
   <?php foreach ($mobility_aidsRecords as $record): ?>
   <?php $in_list = $record['mobility_aid_category:label'] ?>
    <?php if ($name == $in_list ):?>
      <option value="<?php echo $value; ?>"><?php echo $name; ?></option>
      <?php endif  ?>
   <?php endforeach; ?><?php endforeach; ?>
</select> 

Thanks,

Jerry Kornbluth

Hi Jerry,

If your already pulling all of the relevant records for the section and you only want to show items in the drop down that have been already selected, it might be easier to do something like this:

<?php 
//Create an array to store the values that have been selected
$selectArray = array(); 
//foreach section item
foreach($mobility_aidsRecords as $record){ 
  //If the record has something selected for mobility_aid_category 
  if(@$record['mobility_aid_category:label']){
    //If the selected value isn't already in the array
    if(!in_array(@$record['mobility_aid_category:label'],$selectArray)){ 
      //Add it to the $selectArray
      $selectArray[$record['mobility_aid_category']] = $record['mobility_aid_category:label']; 
    }
  } 
}
?>

<select name="mobility_aid_category" >
  <option value= "">Choose The Category To Display And Click/Tap The Search Button</option>
  <?php foreach ($selectArray as $value => $name): ?>
    <option value="<?php echo $value; ?>"><?php echo $name; ?></option>
  <?php endforeach; ?>
</select> 

Let me know if this doesn't work.

Thanks

Greg

Hi Greg,

Thanks for setting this straight.

It works perfectly, and makes much more sense.

(Now if I can only apply the principle to other issues.)

Hope you enjoyed the time off for the holidays,

Jerry Kornbluth