"; echo ""; echo "ID"; echo "Name of Members"; echo "Group Head"; echo "Members"; echo ""; while($row=mysql_fetch_array($getMembers)){ $gID= $row['u_id']; $gFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gID'"),0); $gLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gID'"),0); $getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0); ?>".$row['u_id'].""; echo "".$row['group_name'].""; echo "".$gLname. ", ".$gFname.""; echo "".number_format($getMember,0,'.',',').""; echo ""; } echo ""; } ?>