chamilo / chamilo-lms

        $sql = "SELECT * FROM $table_categories";

        $result = Database::query($sql);

        $category = array();

        while ($row = Database::fetch_array($result, 'ASSOC')) {

            $category[$row['code']] = $row['name'];

        }

        return $category;

    }

            $result = Database::query($sql);

            $visibleFolders = array();

            while ($row = Database::fetch_array($result, 'ASSOC')) {

                $visibleFolders[$row['id']] = $row['path'];

            }

            if ($getInvisibleList) {

                return $visibleFolders;