CodingForums.com - View Single Post - Show different MySQL rows within the same results

howard-moore · 12-28-2012, 10:29 PM

I've been doing a bit more reading, and basically what I am looking to do is a sort of dynamic menu using PHP and MySQL, but utilising the above fields. The issue I have is that I want the results to sort as follows:

1. Sort TOP_PAGE's by page_order
2. Show corresponding SUB_PAGE's below each 'parent' TOP_PAGE
3. Sort the SUB_PAGE's at '2' above by page_order

Thanks,
Neil

12-28-2012, 10:29 PM	PM User \| #8
howard-moore Regular Coder Join Date: May 2008 Posts: 114 Thanks: 13 Thanked 0 Times in 0 Posts	I've been doing a bit more reading, and basically what I am looking to do is a sort of dynamic menu using PHP and MySQL, but utilising the above fields. The issue I have is that I want the results to sort as follows: 1. Sort TOP_PAGE's by page_order 2. Show corresponding SUB_PAGE's below each 'parent' TOP_PAGE 3. Sort the SUB_PAGE's at '2' above by page_order Thanks, Neil