Make a Dropdown list sort by number

Question

I made a dropdown menu and tried to list it. But the list in the db doesn't start with "H01" so my dropdown starts with "H40"

How can I replace the code:

like 'H%'

Code and Frontend

Answer 1

You need to add order_by to your select query.

For example

<?php
  $query = "SELECT * FROM `status` ORDER BY `status`.`status` ASC";
?>

Here status field has values like H01, H02, H03, ... H10

Answer 2

Please add order by your_column_name ASC in your query.