Help With List And Sorting

Hi,

Okay, no problem.  First we need to compile an array with all selected values from that field like this:

<?php
  $selectedClearingHouseClaimsOptions = array();
  $memberCompanies = mysql_select("member_companies", "member_type = 'Independent'");
  
  foreach ($memberCompanies as $company) {
    $tempArray = array_filter(explode("\t", trim($company['accepts_clearing_house_claims'], "\t")));
    $selectedClearingHouseClaimsOptions = array_merge($selectedClearingHouseClaimsOptions, $tempArray);
  }
  
?>

After that, we look through all possible options using the getListOptions() function.  We then have an if statement that looks for the current value in our selected values array.

<select name="accepts_clearing_house_claims" onchange = "populateAdjusterList(this, 'independent');"  // populate list code in j >

<option value="">All</option>

<?php foreach (getListOptions("member_companies", 'accepts_clearing_house_claims') as $value => $label): ?>
  <?php if (in_array($value, $selectedClearingHouseClaimsOptions)): ?>
    <option value = "<?php echo $value;?>" <?php selectedIf($value, @$_REQUEST['accepts_clearing_house_claims']);?>><?php echo $label;?></option>
  <?php endif; ?>

<?php endforeach ?>

</select>



That should give you the results you are looking for.  Please note that this code snippet hasn't been tested, so there may be a few bugs/typos.

Hope this helps,