PHP - Need Help Getting My Side Nav To Work With Loops (depending On Top Nav)

Hello.

I recently posted about getting my top nav to work which it does now (with thanks) but im having trouble getting my side navs to work. i have tried various things but i think its just a case of getting the where clause right.

see what you think. any help would be great

these are my files.

includes/navL1.php  - which does the top navigation
includes/navL2.php  - which does the left navigation main
includes/navL3.php  - which does the left navigation sub
admin/layouts/admin_topnav.php
admin/layouts/admin_leftnav.php
admin/layouts/index.php



ok so. admin topnav.php code looks like this and works

Code: [Select]
<?PHP
require_once("../includes/initialize.php");
global $topNav;
global $pageName;
?>
<div id="navWrapper">
<?PHP
$topNav = navL1::find_all();
?>
  <div id="ddtabs3" class="solidblockmenu">
<ul>
<?PHP foreach($topNav as $topNavs): ?>

<li><a <?PHP echo ($pageName == $topNavs->title ? 'class="selected"' : '')?> href="<?PHP echo $topNavs->title; ?>.php" id="<?PHP echo $topNavs->title; ?>"><?PHP echo $topNavs->title; ?></a></li>
<?PHP endforeach; ?>
</ul>
</div><!--  #ddtabs3-->
</div><!--  #navWrapper-->


now i need when a top nav is selected i need the correct left nav main and subs to show.

this is how my left nav looks at the moment

Code: [Select]
<?PHP
require_once("../includes/initialize.php");
global $topNav;
global $pageName;
?>

SOME ACCORDION SCRIPT GOES HERE

<div class="arrowlistmenu">
<?PHP
$nav1 = navL1::find_all();
$nav2 = navL2::find_by_nav();
$nav2 = navL2::find_by_nav();
?>
<?PHP foreach($nav2 as $nav2s): ?><h3 class="menuheader expandable">

// MAIN LEVEL

<li><a <?PHP echo ($pageName == $nav2s->title ? 'class="selected"' : '')?> href="<?PHP echo $nav2s->title; ?>.php" id="<?PHP echo $nav2s->title; ?>"><?PHP echo $nav2s->title; ?></a></li></h3>
<?PHP endforeach; ?>


// SUB LEVEL

<ul class="categoryitems">
<?PHP foreach($nav3 as $nav3s): ?>

<li><a <?PHP echo ($pageName == $nav3s->title ? 'class="selected"' : '')?> href="<?PHP echo $nav3s->title; ?>.php" id="<?PHP echo $nav3s->title; ?>"><?PHP echo $nav3s->title; ?></a></li>
<?PHP endforeach; ?>
</ul>

</div><!-- #End arrowlistmenu -->
<img src="images/wrapper/loading.gif" alt="loading..." id="Pageloading" height="28" width="28" style="visibility:hidden;float:left;" />



this is the code im trying to get to work in my includes files that i can seem to get my head around


includes/navL2.php
Code: [Select]
public static function find_by_nav(){
global $database;
global $topNav;
$sql = "SELECT * FROM ".self::$table_name." WHERE title="$topNav" LIMIT 1";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}

the find_by_sql($sql) looks like this but i dont think you need it
Code: [Select]

public static function find_by_sql($sql){
global $database;
$results_set = $database->query($sql);
$object_array = array();
while($row = $database->fetch_array($results_set)){
$object_array[] = self::instantiate($row);
}
return $object_array;
}


im trying to use the same code to pull the sub levels inside includes/navL3.php



if any of this makes sense please could you point out whats wrong
thanks
ricky