ElkArte Community Modern, Free, Powerful
Community building forum software

<?php
# ...

    $db = database();

    # ...

    // Grab the categories sorted by cat_order.
    $request = $db->query('', '
        SELECT id_cat, cat_order
        FROM {db_prefix}categories
        ORDER BY cat_order',
        array(
        )
    );
    while ($row = $db->fetch_assoc($request))
    {
            # ...
            $cat_order[$row['id_cat']] = $row['cat_order'];
    }
    $db->free_result($request);

    # ...

<?php

    use Elkarte\DB;

    # ...

        // Grab the categories sorted by cat_order.
        $q = DB::query('
            SELECT id_cat, cat_order
            FROM {db_prefix}categories
            ORDER BY cat_order',
            []
        );
        while ($row = $q->fetch_assoc) {
            # ...
            $cat_order[$row['id_cat']] = $row['cat_order'];
        }
        $q->free;

        # ...