01.<? include('config.php');
02.$w1 = 1;
03.
04.$sa1 = $mysqli->query("SELECT * FROM plot WHERE admin_id = '".$_SESSION['idn']."' ORDER BY pl_id DESC LIMIT 50");
05.while($saa1=$sa1->fetch_assoc()){ $i2 = $i2 + 1; ?>
06.
07.<tr>
08. <td style="padding-top: 5px">
09.<input type="checkbox" class="form-control" name="chkDel[]" id="chkDel<?= $i2;?>" value="<?= $saa1["pl_id"];?>">
10.</td>
11.
12. <td><center><p style="margin: 0px 0px"><?= $w1; ?></p></center></td>
13.
14. <td><center><p style="margin: 0px 0px">PL<?= $saa1['pl_id']; ?></p></center></td>
15.
16. <? $yy1 = $mysqli->query("SELECT * FROM province WHERE pro_id = '".$saa1['pro_id']."'");
17. $y1 = $yy1->fetch_assoc(); ?>
18. <td><center><p style="margin: 0px 0px"><?= $y1['pro_name']; ?></p></center></td>
19.
20. <? $yy2 = $mysqli->query("SELECT * FROM district WHERE dis_id = '".$saa1['dis_id']."'");
21. $y2 = $yy2->fetch_assoc(); ?>
22. <td><center><p style="margin: 0px 0px"><?= $y2['dis_name']; ?></p></center></td>
23.
24. <? $yy3 = $mysqli->query("SELECT * FROM subdis WHERE sub_id = '".$saa1['sub_id']."'");
25. $y3 = $yy3->fetch_assoc(); ?>
26. <td><center><p style="margin: 0px 0px"><?= $y3['sub_name']; ?></p></center></td>
27.
28. <td><center><p style="margin: 0px 0px"><?= $saa1['pl_moo'];?></p></center></td>
29. <td><center><p style="margin: 0px 0px"><?= $saa1['pl_position'];?></p></center></td>
30. <td><center><p style="margin: 0px 0px"><?= $saa1['pl_name'];?></p></center></td>
31.</tr>
32.<? $w1++; } $mysqli->close(); ?>
)
