Ordering Joomla menus in code

Question

I am trying to order jos_menu items by the order in which they appear on the menu, i.e i am using jdatabase sql queries to fetch menu objects then itarate through them to display them i know that this is accomplished in other components table by the ordering column, however i cant seem to find the ordering column on the jos_menu table. How will i ?accomplish this>

Answer 1

Before you start, you should look into Joomla's Menu library. Maybe it already does what you need.

Menu table uses nested structure. Menu items have parents and levels. Ordering is defined by lft and rgt columns. To get a flat list of items ordered by "ordering" you can order by lft.