在php查询中排序数字

Question

I have a code here it works but i want to sort it out by min to max, what should i do?

 <!-YEAR SELECTION->
                        <select name="year[]" id="year" class="selectpicker" data-style="btn-default" class="selectpicker form-control" multiple>
                        <?php 
                          $sql_query =  "SELECT DISTINCT proj_year FROM lfpstatustable1";
                          $result = mysqli_query($conn,$sql_query);
                          while ($row = mysqli_fetch_array($result)){
                          echo "<option value='".$row[proj_year]."'>" . $row[proj_year] . "</option>";
                          }

                        ?>
                        </select>

Answer 1

In your sql query add order by SELECT DISTINCT proj_year FROM lfpstatustable1 order by proj_year asc