"; echo ""; echo "GROUP ID"; echo "GROUP NAME"; echo "GROUP HEAD"; echo "MEMBERS"; echo ""; while($row=mysql_fetch_array($getSalesGroup)){ $gHead = $row['group_head']; $gID= $row['gid']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gHead'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?>".$row['gid'].""; echo "".$row['group_name'].""; echo "".$gLname. ", ".$gFname.""; echo "".number_format($getMember,0,'.',',').""; echo ""; } echo ""; exit(); } ?>