MySQL数据库中预先选择的下拉列表值

Though I have researched, I couldn't find any solution for this. I need to get the database value ("Default") as the pre-selected value of the drop down list.

<select name="listCustomer" id="listCustomer">
    <?php 
    $sql = mysqli_query($connection,"SELECT customer_name FROM customers");
    while ($row = mysqli_fetch_array($sql,MYSQLI_ASSOC)){
    echo "<option value=\"" .   $row['customer_name'] . "\">" . $row['customer_name'] . "</option>";}
    ?>
</select>

Can you please help me on this?

Just create a variable before the echo, something like:

$selected = ((strtolower($row['customer_name']) == 'default') ? 'selected' : '');

then change the echo to this:

echo '<option '.$selected.' value="'.$row['customer_name'].'">'.$row['customer_name'].'</option>';

This can be accomplished using an if statement on the customer_name

$sql = mysqli_query($connection,"SELECT customer_name FROM customers");
while ($row = mysqli_fetch_array($sql,MYSQLI_ASSOC)){
     if($row["customer_name"] === "Default"){
      echo "<option value=\"" .   $row['customer_name'] . "\" selected>" . $row['customer_name'] . "</option>";
     } else {
       echo "<option value=\"" .   $row['customer_name'] . "\">" . $row['customer_name'] . "</option>";
     }
 }
 ?>

Note the selected tag on the first echo.

$query="SELECT customer_name FROM customers";
$result = @mysql_query ($query);
echo "<select name=customer_name value=' '>";
while($drop=@mysql_fetch_array($result)){
echo "<option value=$drop[customer_name]>$drop[customer_name]</option>";
}
echo "</select>";