sql query in drop down option

Question

I am trying to a display options in dropdown by database.Name of table is location and loc is a column in table of varchar datatype

<select style="width: 200px;" name="location" id="myselect" onchange="window.location='enable1.php?id='+this.value+'&pos='+this.selectedIndex;">
  <option value="All">All</option>
  <?php

  $sql="select * from location";
  var_dump($sql);
  $query=mysqli_query($conn,$sql);
  echo "1";
  while($row=mysql_fetch_array($query))
  {
      echo "<option value='$row[loc]'>'$row[loc]'</option>";
  }
    ?>

</select>

But when I load the page I Dont get any output in dropdown. Only 1 option and that is "ALL". Var_dump() also outputs nothing

score 1 · Accepted Answer · answered Jun 30 '15 at 17:06

1

Remove the single quotes around array keys:

echo "<option value='$row[loc]'>$row[loc]</option>";// line 123

answered Jun 30 '15 at 17:06

mike.k

3,277
1
12
18

Okay that helped but now I dont get any result in dropdown – Prabhjot Singh Kainth Jun 30 '15 at 17:44
If you view the source does it contain ` – mike.k Jun 30 '15 at 18:51
view source shows this – Prabhjot Singh Kainth Jul 01 '15 at 05:25
1

Get rid of var_dump and echo. Switch to the function mysqli_fetch_assoc from mysql_fetch_array – mike.k Jul 01 '15 at 11:54

sql query in drop down option

1 Answers1