I've got this structure:
Code:menu ------------ option_id name options_order ------------- option_id parent_id order
"parent_id" specifies which submenu a menu item belongs to (which parent menu item it has). The value for top level menu items is 0.
"order" specifies order within same submenu.
I need to get a list with all the menu items, plus the name of its parent menu item ("top level" if parent_id = 0).
I could have used just one table, but now it's too late. I'd rather keep it this way right now.
How could I get what I want in a query?