title: How to get values from SQL query made by php?
body: <p>So I made a query like this</p>
  
  <pre><code>    global $connection;
      $query = "SELECT * 
      FROM streams ";
      $streams_set = mysql_query($query, $connection);
      confirm_query($streams_set);
  </code></pre>
  
  <p>in my DB there are filds</p>
  
  <p>ID, UID, SID, TIME (all INT type exept time)</p>
  
  <p>So I am triing to print query relult into form</p>
  
  <pre><code>          &lt;form&gt;
  
    &lt;select class="multiselect" multiple="multiple" name="SIDs"&gt;
  
             &lt;?php        
  
      global $connection;
      $query = "SELECT * 
      FROM streams ";
      $streams_set = mysql_query($query, $connection);
      confirm_query($streams_set);
  
  
              $streams_count = mysql_num_rows($streams_set);
              for ($count=1; $count &lt;= $streams_count; $count++) {
          echo "&lt;option value=\"{$count}\"";
          echo "&gt;{$count}&lt;/option&gt;";
      } 
            ?&gt;
            &lt;/select&gt;
            &lt;br/&gt;
            &lt;input type="submit" value="Submit Form"/&gt;
              &lt;/form&gt;
  </code></pre>
  
  <p>How to print out as "option" "values" SID's from my sql query?</p>