',email,'') as EmailAddress " . "from Users where isDeleted=0 and UserID in " . "(select UserID from ProjectMembers " . "where projectid=" . $_SESSION["ProjectId"] . ") " . $rstring . "order by LastName, FirstName"; //echo "sql:\n" , $sql , "\n"; function ToAll() { global $rstring; $sql = "select email from Users where isDeleted=0 and UserID in " . "(select UserID from ProjectMembers " . "where projectid=" . $_SESSION["ProjectId"] . ") " . $rstring . "order by LastName, FirstName"; $res=GetResultset($sql); if(!$row = mysql_fetch_assoc($res)) { return false; } $tComma=""; do { $tList= $tList . $tComma . $row["email"]; $tComma=";"; } while ($row = mysql_fetch_assoc($res)); DisConnect(); return $tList; } function loadRoles() { global $rID; echo "All Roles\n"; $sql = "Select RoleId,RoleName from Roles where isDisabled=0 order by RoleName"; $res=GetResultset($sql); if(!$row = mysql_fetch_assoc($res)) { return false; } do { if ($row["RoleId"] == $rID) echo "" , $row["RoleName"] . "\n"; else echo "" , $row["RoleName"] . "\n"; } while ($row = mysql_fetch_assoc($res)); DisConnect(); } ?>

'; include_once '../inc/StandardButtons.inc'; echo ''; ?>

>Contacts

(Only portal account holders appear in the above list)