Okay this is the error that I get PHP Fatal error: MySQL error 1054: Unknown column 'pages_title' in 'order clause' :: select * from ezpages where status_header = 1 order by header_sort_order, pages_title ==> (as called by) \WWW-Server\........\includes\modules\sideboxes\bootstrap\ezpages_drop_menu.php on line 23 <== in \WWW-Server\.......\includes\classes\db\mysql\query_factory.php on line 714.

Looking at the tables using php admin the pages_title is not in ezpages but in ezpages_content

I have tried this at line 23 and seems to work:

$page_query = $db->Execute("select *, ".TABLE_EZPAGES_CONTENT .".pages_title from " . TABLE_EZPAGES . " JOIN ". TABLE_EZPAGES_CONTENT. " ON ezpages.pages_id = ". TABLE_EZPAGES_CONTENT .".pages_id where status_header = 1 order by header_sort_order, pages_title");


Hope that helps others get the menu into their template this is my first foray into coding for a while and I was never an expert anyway. If anyone sees any issues regarding security or anything else to do with the query or performance then please feedback or comment. I have not done anything regarding the CSS and boostrap yet but will continue to test.

Thanks