如何在没有数据时隐藏选择选项

Question

I'm building a drop-down list with options containing data from a database and want to hide options which have zero data.

I have tried an if statement using continue but failing to catch the live data values from the database.

      <select name='Database' title="Choose from database">
        <option value="">All</option>
        <?php foreach($database as $row):
          if ($row['topic'] == 0) {
            continue;
          }
          else {
          ?>
            <option value="<?= $row['topic']; ?>"
            <?php if ($row['topic'] == $_SESSION['prosess']){echo " 
            selected";}?>>
            <?= $row['topic']; ?>
          <?php }?>
          </option>
        <?php endforeach; ?>
      </select>

Is there any clever javascript-, php-, etc. code that can deactivate/hide options from a database which are empty.

Answer 1

Add this in your css:

select option:empty { display:none }