retrieving data from mysql DB to a drop down list

Question

This is my code but I don't seem to get anything in the dropdown list. Is there something else I'm supposed to do besides this? Or is there something wrong with my code?

<div class="span10 offset1">
                <div class="row">
                        <h3> Add catagory</h3>
                    </div>
                      <select class="selectpicker" data-style="btn-success" >';

                        <?php
                   include('database.php');

        $query = "SELECT cat_name  FROM  catagory";
$result = mysql_query ($query);
echo "<select name='dropdown' value=''><option>Dropdown</option>";
while($r = mysql_fetch_array($result)) {
 echo "<option value=' " . $row['cat_name'] . " '>" . $row['cat_name'] . " </option>";
}
echo "</select>";
?>

</div>

aynber · Accepted Answer · 2016-06-09 15:47:55Z

2

You're referencing $row but assigning the result to $r. Just change the variable:

while($r = mysql_fetch_array($result)) {
    echo "<option value=' " . $r['cat_name'] . " '>" . $r['cat_name'] . " </option>";
}

answered Jun 9, 2016 at 15:47

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

1 Comment

aynber Over a year ago

Eh, guess I'll just have to speed up my typing skills, then!

Neirid · Accepted Answer · 2016-06-09 15:48:23Z

1

Your variables names look wrong

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

You loop through the results using $r but use $row[] within the loop. It should probably read

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

answered Jun 9, 2016 at 15:48

Neirid

3632 silver badges8 bronze badges

1 Comment

Neirid Over a year ago

Make sure that you're connected to the MySQL server, and that you've selected the correct database to run your queries against by using mysql_select_db($database_name)

Collectives™ on Stack Overflow

retrieving data from mysql DB to a drop down list

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related