query($enCoding); $row = 0; $table = 0; $strSql = "SELECT a.group_seq, a.group_name, b.member_name, b.member_cellphone "; $strSql .= "FROM t_group a "; $strSql .= "LEFT OUTER JOIN t_group_member b ON a.group_seq = b.group_seq "; $strSql .= "WHERE a.deleted_yn = 'N' "; $strSql .= "ORDER BY a.group_seq, b.member_name "; $objConn->query($strSql); if($objConn->nf() != 0) { $chkFirst = 0; while($objConn->next_record()) { if($chkFirst == 0) $pre_group_seq = $objConn->f("group_seq"); $group_seq = $objConn->f("group_seq"); if($pre_group_seq != $group_seq) { $table++; $row = 0; } $tmpArr[$table][$row][0] = $group_seq; $tmpArr[$table][$row][1] = $objConn->f("group_name"); $tmpArr[$table][$row][2] = $objConn->f("member_name"); $tmpArr[$table][$row][3] = $objConn->f("member_cellphone"); //echo $table."-".$row."
"; //echo $pre_group_seq."-".$group_seq."
"; $pre_group_seq = $group_seq; $row++; $chkFirst++; } echo "\n"; echo " \n"; echo " \n"; echo " \n"; for($i=0; $i<($table+1); $i++) { if(($i+1)%3 == 0) echo " \n"; echo " \n"; if(($i+1)%3 == 0) echo " \n"; } echo "

\n"; echo " ±×·ìÃß°¡\n"; echo "

\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " ±×·ì¸í#".($i+1)." ".$tmpArr[$i][0][1]." \n"; echo " \n"; for($j=0; $j\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo " ".($j+1)." ".$tmpArr[$i][$j][2]."  ".$tmpArr[$i][$j][3]." \n"; echo " ¸â¹öÃß°¡ "; echo "

"; } ?>