Dynamic List/Menu help

Trying to build a database search form, (php Mysql) everything ok until I created a dynamic List/Menu using the DW (CS4) wizard. I'm getting duplicates in my results. How do I stop duplicates and get uniques instead. Here's the code. Someone please help....

select nalemme="select2" id="select2">
      <option value="">Country</option>
      <?php
do { 
?>
      <option value="<?php echo $row_associations['Site_ID']?>"><?php echo $row_associations['Bcode_Community']?></option>
      <?php
} while ($row_associations = mysql_fetch_assoc($associations));
  $rows = mysql_num_rows($associations);
  if($rows > 0) {
      mysql_data_seek($associations, 0);
      $row_associations = mysql_fetch_assoc($associations);
  }
?>
    </select>