01.<?php
02.include("connect.php");
03.$strSQL = "SELECT tb_name.id, COUNT( subtname.idss ) AS cou
04.FROM tb_name LEFT JOIN subtname ON tb_name.id = subtname.idss GROUP BY tb_name.id ORDER BY tb_name.num";
05.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
06.$num_rows = mysql_num_rows($objQuery);
07. $arr = array();
08.
09. while ($rows = mysql_fetch_array($objQuery,MYSQL_ASSOC)) {
10. $arr[] = (object) $rows;
11. }
12.foreach ($arr[0] as $obj) {
13.?>
14.แสดงแผล- <?php echo $obj->cou;?><br>
15.<?php
16.}
17.?>
