title: woocommerce pull data into a dynamic dropdown list form
body: <p>Trying to extract data into a dropdown list but no results are showing </p>
  
  <pre><code>  &lt;form method="POST" action="city_processProduct.php?action=cityDest"&gt;
  
    &lt;td class="label" align="center"&gt;
    &lt;?php  global $wpdb;
    // get all countries
    $sql1 = "SELECT city_countries_country
             FROM city_callingfrom_countries
             ORDER BY city_countries_country";
    $result1 = $wpdb-&gt;get_results($sql1);
    ?&gt;
    &lt;select name="dest[]" size="5" multiple&gt;
    &lt;?php global $wpdb;
    while($row1 = $wpdb-&gt;get_results($result1)) {
      extract($row1);
      echo"&lt;option value='$row1-&gt;$city_countries_country&lt;/option&gt; ";
    }
    ?&gt;
    &lt;/select&gt;
    &lt;/form&gt;
  </code></pre>
  
  <p>However when i  echo db table row without form it gets results</p>
  
  <pre><code>&lt;?php  global $wpdb;
    $sql1 = $wpdb-&gt;get_results ("SELECT city_countries_country
             FROM city_countries
             ORDER BY city_countries_country");
        foreach ($sql1 as $result){
        echo  "$result-&gt;city_countries_country&lt;/br&gt;";
        }
  ?&gt;
  </code></pre>