Zen Cart将MySQL结果放置在MoveNext(）标记内的数组中

我想知道是否可以提供一些帮助，我想把以下内容放在一个数组中，这样我就可以使用PHP更改排序顺序，因为通过MySQL排序似乎不起作用，但不确定如何进行，如果有任何帮助，我将不胜感激。

                      global $db;

                  $sql = "select c.categories_id, cd.categories_name, cd.categories_menu_name, c.parent_id, c.sort_order 
                        from " . TABLE_CATEGORIES . " c left join " . 
                        TABLE_HIDE_CATEGORIES . " hc on c.categories_id = hc.categories_id, " . 
                        TABLE_CATEGORIES_DESCRIPTION . " cd 
                        where c.categories_id = cd.categories_id 
                        and c.categories_status=1 
                        and (hc.visibility_status IS NULL or hc.visibility_status < 2) 
                        and c.show_in_drop2=1 and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'  and cd.categories_id = ".(int)$sub_categories->fields['categories_id']." 
                        order by c.sort_order, cd.categories_name, c.parent_id";
                  //$sql = "select categories_name, categories_id from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = ".(int)$sub_categories->fields['categories_id']." order by categories_name";

                  $sub_categories_name = $db->Execute($sql);
                  if ($sub_categories_name->RecordCount() > 0) {
                    //$result .= 'Cat ID: ' . $sub_categories_name->fields['categories_id'] . '<br /> Cat Name: ' . $sub_categories_name->fields['categories_name'] . '<br /> Sort Order: ' . $sub_categories_name->fields['sort_order'] . '<br />';
                    if (strlen($sub_categories_name->fields['categories_menu_name']) < 1) {
                        $sub_cat_menu_name = $sub_categories_name->fields['categories_name'];
                    } else {
                        $sub_cat_menu_name = $sub_categories_name->fields['categories_menu_name'];
                    }
                    //BOF: Split into multiple columns
                    if ($sub_categories_name->fields['categories_id'] == 26) {
                        $column_split = '<li class="column-split"><span>&nbsp;</span>';
                    } else {
                        $column_split = '';
                    }
                    //EOF: Split into multiple columns
                    $result .= $column_split.'<a href="' . zen_href_link(FILENAME_DEFAULT, 'cPath=' . $sub_categories_name->fields['categories_id']) . '">' . $sub_cat_menu_name . '</a>';
                  }
              $sub_categories->MoveNext();
            }

非常感谢，

Costa