";
echo "";
echo "| Rec. NO | ";
echo "Group Name | ";
echo "Name of Members | ";
echo "Group Head | ";
echo "";
while($row=mysql_fetch_array($getLstofMembers)){
$gHead = mysql_result(mysql_query("SELECT `group_head` FROM `db_sales_group` WHERE `gid`='$selGroupNameID'"),0);
$uID= $row['u_id'];
$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);
$mFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$mLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
$getMember = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `vts_users` WHERE `sales_group`='$gID'"),0);
?>".$row['u_id']."";
echo "| Group #".$row['sales_group']." | ";
echo "".$mLname. ", ".$mFname." | ";
echo "".$gLname. ", ".$gFname." | ";
echo "
";
}
echo "";
exit();
}
?>