Dear sir/madam,
I have the following query wich works but now idd like to get the a.title and a.label from a different tabel known as ".$_SESSION['pages_content']."
How do i fit this extra query into this one?
Do i add an outer join or do i make a union?
It eventually fills in a function for a menu.
Does anybody have a luminous idea, idd rrrrealy apreciated it.
I have the following query wich works but now idd like to get the a.title and a.label from a different tabel known as ".$_SESSION['pages_content']."
How do i fit this extra query into this one?
Do i add an outer join or do i make a union?
It eventually fills in a function for a menu.
Does anybody have a luminous idea, idd rrrrealy apreciated it.
Code:
//this works SELECT a.ID, a.parent, a.title, a.label, a.link, a.sequence, Deriv1.Count FROM ".$GLOBALS['pages']." a LEFT OUTER JOIN (SELECT parent, COUNT(*) AS Count FROM ".$GLOBALS['pages']." WHERE menu='top' GROUP BY parent) Deriv1 ON a.ID = Deriv1.parent WHERE a.parent=" . $parent1 . " AND menu='top' order by sequence ASC