Fetching data to HTML dropdown list to from database

Question

I need to fetch user's company type to dropdown list from database. According to my coding data is not fetching properly.I tried to print the result but even it's not outputting anything. Database variable name is 'type'. Could someone give any help?

<select name="type" class="form-control">
              <?php


mysql_connect('localhost', 'root', '123');
mysql_select_db('db1');

$sql= "SELECT type FROM users";
$result= mysql_query($sql);
echo "$result";

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


?>

 </select>

Michael Moxley · Accepted Answer · 2017-09-17 12:27:47Z

1

Here is what I use on my forms (modified for your terms).

    mysql_connect('localhost', 'root', '123');
    mysql_select_db('db1');
    $sql = "SELECT type FROM users";
    $result = mysql_query($sql) or die ("Error in query: $sql. " . mysql_error());
    if (mysql_num_rows($result) > 0){
       while($row = mysql_fetch_object($result)){
          echo "<option value=\"".$row->type."\">".$row->type."</option>";}}
  }

edited Sep 17, 2017 at 12:27

answered Sep 17, 2017 at 12:09

Michael Moxley

361 silver badge7 bronze badges

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

3 Comments

Ryan Oscar Over a year ago

Did you test this code? It's not working either. The dropdown list is empty. @Michael Moxley

Michael Moxley Over a year ago

It should work, it's copy / pasted from a working form of mine. I know this is simple, but is the table and SQL correct?

Ryan Oscar Over a year ago

Yeah I just double checked the database names and the table. No idea what's wrong @Michael Moxley -_-

Collectives™ on Stack Overflow

Fetching data to HTML dropdown list to from database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related