Problem with SQL query (get parent title)

[anandg]

I have a horizontal menu. When you click on a horizontal menu option, then a left subnavigation will show up.
I have created a query that will show the menu text of the parent from a left subnavigation option.

For example, the horizontal menu is:
1. Home
2. Collection
3. Contact

Subnavigation for Collection is
2.1 Collection 1
2.2 Collection 2
2.3 Collection 3

If I am at the page 2.2, then I want to show "Collection" as the parent on the page.
But the query below doesn't work.
Can anyone see what is wrong with this query?

Code: Select all

global $gCms;
$db =& $gCms->GetDb();
$vars =& $gCms->variables;

$query = "
SELECT menu_text 
FROM ".cms_db_prefix()."content 
WHERE content_id = 
(
   SELECT parent_id 
   FROM ".cms_db_prefix()."content 
   WHERE content_id = '".$vars['content_id']."'
);";

$row = $db->GetRow($query);
print_r($row);

[anandg]

I have already tested parts of the query.
The query between the parenthises works:

Code: Select all

SELECT parent_id 
FROM ".cms_db_prefix()."content 
WHERE content_id = '".$vars['content_id']."'

The query outside the parenthises also works. I used this for example:

Code: Select all

SELECT menu_text 
FROM ".cms_db_prefix()."content 
WHERE content_id = 16";

It should work but it doesn't. Can anyone help me?

[rtkd]

hmm..., i'm not sure, but i dont think u can have nested select statements (as far as i know that is!), tho that code would make scence.

/*
@ EDIT
*/

i looked it up. u CAN have nested select

try taking out the ; in the nested select statement. WHERE content_id = '".$vars['content_id']."');";
the examples ive seen go without.

[cyberman]

I have created a query that will show the menu text of the parent from a left subnavigation option.

Don't know if I've understand right but I think you can do that with MenuManagers options and without special queries.

Can you post your menu manager command for left submenu?

[anandg]

My menu manager command is:

Code: Select all

{* .currentpage - The active/current page  *} 

{if $count > 0}

{* 
show the parent (title) from the current node (page) 
also show the parent (title) if its the parent itself
*}
{foreach from=$nodelist item=node}
    {if $node->current == true and $node->haschildren == true}    
        <h1>{$node->alias}</h1>
    {/if}
{/foreach}

<ul class="clearfix">

{foreach from=$nodelist item=node}

{if $node->current == true and $node->haschildren == false and $node->alias != 'home'}
    <li>{$node->menutext} 
{elseif $node->haschildren == false and $node->alias != 'home'}
    <li><a href="{$node->url}"> {$node->menutext} </a>
{/if}
{/foreach}

</ul>
{/if}

[cyberman]

No, I've meaned menu manager call, not the template ...

There's a parameter for menu manager available, which can do, that element and only it's children are shown.

[anandg]

Do you mean parameters like start_element, start_level, start_element?
Because i've tried some parameters, but that didn't work. Perhaps I tried it the incorrect way.

Could you give me an example?

[anandg]

I have tried to find a solution for a couple of days and hours, but still no succes.
Can somebody help me?

The last I tried is this:
{cms_module module='menumanager' collapse='1' template='zenner_minimal_menu' start_level='2'  show_root_siblings='1'}

Which also doesn't work. It doesn't show the parent title. It only shows the title of the current page.

[anandg]

Finally, I found the solution in the forum!
http://forum.cmsmadesimple.org/index.ph ... 778.0.html

This is the code from the topic that worked:

Code: Select all

// This is only going to step up the tree one level

global $gCms;
$content_id = $gCms->variables['content_id'];
$hm =& $gCms->GetHierarchyManager();

$node =& $hm->getNodeById($content_id);

if ($node != null)
{

    //Grab the parent node
    $parentnode =& $node->getParentNode();
    $ncontent =& $node->getContent();
    $pnode = $ncontent->ParentID();

    //Make sure something came back
    if ($pnode != -1)
    {
        //Get the actual content object
        $content =& $parentnode->getContent();
    } 
    else {
        //Ok no parent lets get the title of this node
        $content = $ncontent;
     }

     if ($content != null) //Just in case
        {
            //Display it's title
            echo $content->Name();
        }   
}

[cyberman]

Thanx for your solution ...