How to get values from SQL query made by php?

Question

So I made a query like this

    global $connection;
    $query = "SELECT * 
    FROM streams ";
    $streams_set = mysql_query($query, $connection);
    confirm_query($streams_set);

in my DB there are filds

ID, UID, SID, TIME (all INT type exept time)

So I am triing to print query relult into form

          <form>

  <select class="multiselect" multiple="multiple" name="SIDs">

           <?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 <= $streams_count; $count++) {
        echo "<option value=\"{$count}\"";
        echo ">{$count}</option>";
    } 
          ?>
          </select>
          <br/>
          <input type="submit" value="Submit Form"/>
            </form>

How to print out as "option" "values" SID's from my sql query?

fire · Accepted Answer · 2010-03-15 14:10:52Z

2

while ($row = mysql_fetch_array($streams_set)) {
 echo '<option value="'.$row['SID'].'">'.$row['SID'].'</option>';
}

answered Mar 15, 2010 at 14:10

fire

21.5k18 gold badges82 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex · Accepted Answer · 2010-03-15 15:03:36Z

2

<form>
  <select class="multiselect" multiple="multiple" name="SIDs">
  <?php      

    global $connection;
    $query = "SELECT * 
    FROM streams ";
    $queryResult = mysql_query($query, $connection);
    while($row = mysql_fetch_assoc($queryResult)) {          
        echo '<option value="'. $row["id"] .'">'. $row["title"] .'</option>';
    } 
 ?>
 </select>
 <br/>
 <input type="submit" value="Submit Form"/>
</form>

You just have to replace the id and title index with your appropriate fields.

answered Mar 15, 2010 at 15:03

Alex

12.5k7 gold badges47 silver badges52 bronze badges

Comments

DrLazer · Accepted Answer · 2010-04-15 09:05:40Z

2

or mysql_fetch_object()

http://php.net/manual/en/function.mysql-fetch-object.php

answered Apr 15, 2010 at 9:05

DrLazer

3,2234 gold badges44 silver badges56 bronze badges

Comments

Seaux · Accepted Answer · 2010-03-15 14:10:42Z

1

Ole Jak, take a look at PHP's mysql_fetch_array http://php.net/manual/en/function.mysql-fetch-array.php, that's what you'll want to do in a while loop :-)

answered Mar 15, 2010 at 14:10

Seaux

3,5772 gold badges31 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to get values from SQL query made by php?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related