ขอคำแนะนำ ในการเขียน php สำหรับแสดงรายการสินค้าที่ใกล้หมดจาก Stock ต่ำกว่า 10 ชิ้น

<?php include('header.php'); ?>

  <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            สรุปรายการ
           
          </h1>
          
        </section>

        <!-- Main content -->
        <section class="content">
          <!-- Small boxes (Stat box) -->
          <div class="row">
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-aqua">
                <div class="inner">
                  <h3>				  								  
				  <?php
                      $sql1="SELECT DISTINCT
Count(tb_ordered.ordered_no) AS count
FROM
	tb_ordered";
                      $result1=$cls_con->select_base($sql1);
                      while($row1=mysqli_fetch_array($result1))
                      {
                          echo $row1['count'];
                      }
                      
                      ?></h3>
                  <p>รายการสั่งซื้อ</p>
                </div>
                <div class="icon">
                  <i class="ion ion-bag"></i>
                </div>
           
              </div>
            </div><!-- ./col -->
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-green">
                <div class="inner">
                  <h3><?php
                      
                          $sql2="
                                SELECT
                                    tb_ordered.ordered_no,
                                    tb_ordered.ordered_discount,
                                    tb_ordered.ordered_status,
                                    tb_ordered.ordered_date
                                FROM
                                    tb_ordered
                                ";
                        $sql2.=" where";
                        $sql2.=" ordered_date>='".date('Y-m-1 00:00:00')."'";
                        $sql2.=" and ";
                        $sql2.=" ordered_date<='".date('Y-m-30 23:59:59')."'";
                    
                       $result2=$cls_con->select_base($sql2);
                      $i=1;
                       $total[0]=0;
                      while($row2=mysqli_fetch_array($result2))
                      {
                          
                            $total[$i]=$row2['ordered_discount'];
                            $i++;
                      }
                       echo array_sum($total);
                      ?></h3>
                  <p>ยอดขายเดือนนี้</p>
                </div>
                <div class="icon">
                  <i class="ion ion-stats-bars"></i>
                </div>
     
              </div>
            </div><!-- ./col -->
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-gray">
                <div class="inner">
                  <h3><?php
                      $sql3=" select * from tb_member";
                      $numrows3=$cls_con->select_numrows($sql3);
                      echo $numrows3;
                      ?></h3>
                  <p>ลูกค้าทั้งหมด</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                
              </div>
              <div class="small-box bg-blue">
                <div class="inner">
                  <h3><?php
                      $sql3=" select * from tb_product ";
                      $numrows3=$cls_con->select_numrows($sql3);
                      echo $numrows3;
                      ?></h3>
                  <p>สินค้าใกล้หมด</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                
              </div>
            </div><!-- ./col -->
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
              <div class="small-box bg-orange">
                <div class="inner">
                  <h3><?php
                      $sql3=" select * from tb_product";
                      $numrows3=$cls_con->select_numrows($sql3);
                      echo $numrows3;
                      ?></h3>
                  <p>สินค้าทั้งหมด</p>
                </div>
                <div class="icon">
                  <i class="ion ion-person-add"></i>
                </div>
                
              </div>
            </div><!-- ./col -->
            <div class="col-lg-3 col-xs-6">
              <!-- small box -->
          
            </div><!-- ./col -->
          </div><!-- /.row -->
          <!-- Main row -->
          <div class="row">
            <!-- Left col -->
            <section class="col-lg-7 connectedSortable">
                   
          </div><!-- /.row (main row) -->

        </section><!-- /.content -->
      </div>
       
<?php include('footer.php'); ?>