下拉菜单无法从Postgres加载数据

Question

At this time the dropdown menu unable to call data from database Postgres.

<div class="form-group">
    <?php 
        <label>Payee</label>
        <form action="pg-t-payment-update.php" method="post"> 
        <select class="form-control select2"  style="width: 100%;"> 
        <?php 

        $db = pg_connect("host=10.0.32.x port=5432 dbname=postgres user=postgres password=123");
        $sql ="select distinct tenant_name FROM payment_ref_tenancy order by tenant_name asc";
        $result = pg_query($db, $sql);
        $rows = pg_num_rows($result);
        while ($row = pg_fetch_assoc($result)) {
            echo '<option value="'.htmlspecialchars($row['tenant_name']).'"></option>'; 
             }  
     pg_close($db);
    ?>
    </select>
</div>

Answer 1

I think the issue is here:

echo '<option value="'.htmlspecialchars($row['tenant_name']).'"></option>';

change it to:

echo '<option value="'.htmlspecialchars($row['tenant_name']).'">'.htmlspecialchars($row['tenant_name']).'</option>'; 

The correct syntax of option is:

<option value="1">One</option>

here value is the text we get when use it in code, where One is the text which is shown to user.