PHP อยากให้ตารางแสดงผลมีเลขลำดับเรียงกันค่ะ ลองทำแล้วแต่ข้อมูลที่เรียกออกมาไม่ขึ้นหมดเลยค่ะเลขลำดับด้วย

<?php 
    session_start();
    // echo '<pre>';
    // print_r($_SESSION);
    // echo '</pre>';
    include 'condb.php';
    $giu_id = $_SESSION['giu_id'];
    $giu_name = $_SESSION['giu_name'];
    $giu_level = $_SESSION['giu_level'];

    //เงื่อนไขการตรวจสอบสิทธิ์ admin
   if($giu_level!= 'ADMIN') {
        Header("Location: logout.php");
   }
    $query = "SELECT p.*,m.giu_name
            FROM courseindex as p
            LEFT JOIN user_gsb as m ON p.ref_m_id=m.giu_id
            LEFT JOIN course_index_cate as c ON p.course_category=c.cic_id
            WHERE c_del <> 'n'
            ORDER BY p.id ASC"
            or die ("Error:" . mysqli_error());
    $result = mysqli_query($conn, $query) or die("Error in sql : $sql". mysqli_error($sql));
            //echo $query;

    // $query2 = "SELECT ca.*, COUNT(c.id) as ctotal
    // FROM course_index_cate as ca
    // LEFT JOIN courseindex as c ON ca.cic_id=c.course_category
    // GROUP BY ca.cic_id" or die("Error" . mysqli_error());
    // $result2 = mysqli_query($conn, $query2) or die("Error in sql : $sql". mysqli_error($sql));
//    $i=1;
//    while($i = mysqli_fetch_array($result)) {
//        $i++;
//    }

?>
                <!-- Begin Page Content -->
                <div class="container-fluid">
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                    <tr>
                                            <th style="color: #EB008B" width='5%'>id</th>
                                            <th style="color: #EB008B" width='5%'>No.</th>
                                            <th style="color: #EB008B" width='5%'>รหัสวิชา</th>
                                            <th style="color: #EB008B">ชื่อวิชา</th>
                                            <th style="color: #EB008B">หน่วยงานเจ้าของวิชา</th>
                                            <th style="color: #EB008B">เลขที่สัญญา</th>
                                            <th style="color: #EB008B">รายชื่อที่เพิ่ม</th>
                                            <th style="color: #EB008B">ข้อมูล</th>
                                            <!-- <th style="color: #EB008B">แก้ไข</th>     -->
                                        </tr>
                                    </thead>
                                    <tbody>
                                            <?php foreach ($result as $row){
                                                $i = 1;
                                                while($rows = mysql_fetch_array($result1)){ ?>
                                                <tr>
                                                <td align='center'><?php echo $row['id'];?></td>
                                                <td align='center'><?php $i;?></td>
                                                <td><?php echo $row['course_id'];?></td>
                                                <td><?php echo $row['course_name'];?></td>
                                                <td><?php echo $row['agency_course'];?></td>
                                                <td><?php echo $row['contact_id'];?></td>
                                                <td><?php echo $row['giu_name'];?></td>
                                                <td><a href="course_info.php?id=<?php echo $row['id'];?>" style="color: #EB008B;">ดูข้อมูล</a><br>
                                                <a href="course_edit.php?id=<?php echo $row['id'];?>">edit</a><br>
                                                <a href="course_delete.php?id=<?php echo $row['id']; ?>" onclick="return confirm('Confirm Delete');" style="color: red;" >Delete</a>
                                                </td>
                                                <!-- <td><?php echo $row['c_img'];?></td> -->
                                                <!-- <td><a href="course_edit.php?id=<?php echo $row['id'];?>">edit</a></td> -->
                                            </tr>
                                            <?php $i++; } } ?>
                                    </tbody>
                            </table>
                            <?php mysqli_close($conn); ?>