Code Duplication    Length = 6-7 lines in 3 locations

main/inc/lib/thematic.lib.php 1 location

@@ 576-582 (lines=7) @@
573
        }
574
575
        $res = Database::query($sql);
576
        if (Database::num_rows($res) > 0) {
577
            while ($row = Database::fetch_array($res, 'ASSOC')) {
578
                if (in_array($row['id'], $elements)) {
579
                    $data[] = $row;
580
                }
581
            }
582
        }
583
584
        return $data;
585
    }

main/inc/lib/usergroup.lib.php 1 location

@@ 2227-2233 (lines=7) @@
2224
        $sql .= " LIMIT $from,$number_of_items";
2225
2226
        $res = Database::query($sql);
2227
        if (Database::num_rows($res) > 0) {
2228
            while ($row = Database::fetch_array($res, 'ASSOC')) {
2229
                if (!in_array($row['id'], $return)) {
2230
                    $return[$row['id']] = $row;
2231
                }
2232
            }
2233
        }
2234
        return $return;
2235
    }
2236

main/work/work.lib.php 1 location

@@ 3274-3279 (lines=6) @@
3271
            LIMIT 1
3272
            ";
3273
    $result = Database::query($sql);
3274
    if (Database::num_rows($result)) {
3275
        $work = Database::fetch_array($result, 'ASSOC');
3276
        $work['qualification_rounded'] = formatWorkScore($work['qualification'], $parentInfo['qualification']);
3277
3278
        return $work;
3279
    }
3280
3281
    return array();
3282
}