01.<?php
02. $i = 0;
03. while($objResult = mysql_fetch_array($objQuery))
04. {
05. $i++;
06. ?>
07. <tr>
08. <td width="150"> <?php echo $i;?>></td>
09. <td width="150"> <?php echo $objResult["CustomerID"];?></td>
10. <td><?php echo $objResult["Name"];?></td>
11. <td><?php echo $objResult["Email"];?></td>
12. <td><?php echo $objResult["amount_h_all"];?></td>
13. <td><?php echo$objResult["amount_h_used"];?></td>
14. <td><?php echo $objResult["amount_h_used"];?></td>
15. <td><?php echo 'ยอดรวม';?></td>
16. </tr>
17. <?php
18. $sqlSel2 = "SELECT * FROM customer1 WHERE CustomerID = '".$objResult['CustomerID']."' ORDER BY CustomerID ASC ";
19. $sqlQuery2 = mysql_query($sqlSel2);
20. while($sqlArr2 = mysql_fetch_array($sqlQuery2))
21. {
22. ?>
23. <tr >
24. <td><?php echo $sqlArr2['CustomerID']; ?> </td>
25. <td><?php echo $sqlArr2['Name']; ?> </td>
26. <td><?php echo $sqlArr2['Email']; ?> </td>
27. <td><?php echo $sqlArr2["amount_l_all"];?></td>
28. <td><?php echo $sqlArr2["amount_l_used"];?></td>
29. <td><?php echo $sqlArr2["amount_l_balance"];?></td>
30. </tr>
31. <?php
32. }
33.
34.
35.
36. }
37.
38.
39. ?>
