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>

  • Can you clarify what exactly are you trying to accomplish? – Sharky Nov 13 '18 at 8:35
  • i am trying to order joomla menu items via sql – user2293554 Nov 13 '18 at 8:48

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.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.