Setting default item in drop down list html based on SQL query?

Question

Would this be the proper way to add a default value to a drop down menu it HTML?

$vendor_name is determine by a query to get an array of results; that is iterated through to create table rows in HTML. So this value changes dependent on the iteration.

<option value='$vendor_name'>$vendor_name</option>";
while($row = mysqli_fetch_array($result))
{
    echo "<option value='".$row['vendor_id']."'>".$row['name']."</option>";
}

When I attempt this it shows the default value; however, the table that is being created here is used to update an SQL table. If i change any other value in the row related to the $vendor_name without changing the $vendor_name it will not update. Is this because I set the default value?

Yes, you have set default value wrongly, I will share correct example in a while. — Somnath Sinha
– Somnath Sinha, Commented Dec 10, 2017 at 5:52

sharaz ghouri · Accepted Answer · 2017-12-10 08:57:25Z

1

`<?php

while ($row = mysqli_fetch_array($result)) {

echo "<option value='" . $row['vendor_id'] . "'" .( ( $vendor_name == $row['name'])? 'selected': '' ) . ">" . $row['name'] . "</option>"; } ?>

answered Dec 10, 2017 at 8:57

sharaz ghouri

538 bronze badges

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

Comments

Somnath Sinha · Accepted Answer · 2017-12-10 06:14:22Z

0

Below is the correct way of setting default item in DropDown with PHP.

<?php
while ($row = mysqli_fetch_array($result)) {
  $selected = '';
  if ($vendor_name == $row['name']) {
    $selected = ' selected';
  }
  echo "<option value='" . $row['vendor_id'] . "'" . $selected . ">" . $row['name'] . "</option>";
}
?>

answered Dec 10, 2017 at 6:14

Somnath Sinha

6726 silver badges16 bronze badges

Collectives™ on Stack Overflow

Setting default item in drop down list html based on SQL query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related