title: Populating form with data from SQL database
body: <pre><code>while($row = sqlsrv_fetch_array($results)) {
  echo "&lt;option value='".$row['Current_Location']."'&gt;".$row['Current_Location']."&lt;/option&gt;";
  }
  </code></pre>
  
  <p>I have the code above which goes through the database and checks for all the "Current_Locations" within my database it then populates the drop down menu. However, I have some data that are similar such as "Home". Therefore if there's 3 "Home" data in my database, it then display 3 "Home" in the drop down menu. Is there a way to fix this? I thought of doing an if statement maybe to break it but I'm new to PHP and not entirely sure how to approach it.</p>