public static function GetAllUsers($visibleOnly) { $sql = "SELECT U.*, COUNT(M.ID) AS NoOfMaps " . "FROM `" . DB_USER_TABLE . "` U " . "LEFT JOIN `" . DB_MAP_TABLE . "` M ON U.ID=M.UserID " . ($visibleOnly ? "WHERE U.Visible=1 " : "") . "GROUP BY U.ID " . "ORDER BY U.LastName, U.FirstName, U.ID"; $rs = self::Query($sql); $users = array(); while ($r = mysql_fetch_assoc($rs)) { $user = new User(); $user->LoadFromArray($r); $user->NoOfMaps = $r["NoOfMaps"]; $users[$user->ID] = $user; } return $users; }