"members") { mysql_select_db($database_TexITE_DB, $TexITE_DB); if ($_SESSION['LoggedIn'] == "True") { $query_SubNavigation = sprintf("SELECT * FROM navigation WHERE Sec <= %s AND Root = '$submenu' ORDER BY `order`", $_SESSION['Security']); } else { $query_SubNavigation = "SELECT * FROM navigation WHERE Root = '$submenu' ORDER BY `order`"; } $SubNavigation = mysql_query($query_SubNavigation, $TexITE_DB) or die(mysql_error()); $row_SubNavigation = mysql_fetch_assoc($SubNavigation); $totalRows_SubNavigation = mysql_num_rows($SubNavigation); } elseif ($_SESSION['LoggedIn'] == "True") { mysql_select_db($database_TexITE_DB, $TexITE_DB); $query_SubNavigation = "SELECT * FROM navigation WHERE Root = 'members' AND LoggedIn = 'Y' ORDER BY `order`"; $SubNavigation = mysql_query($query_SubNavigation, $TexITE_DB) or die(mysql_error()); $row_SubNavigation = mysql_fetch_assoc($SubNavigation); $totalRows_SubNavigation = mysql_num_rows($SubNavigation); } else { mysql_select_db($database_TexITE_DB, $TexITE_DB); $query_SubNavigation = "SELECT * FROM navigation WHERE Root = 'members' AND LoggedIn = 'N' ORDER BY `order`"; $SubNavigation = mysql_query($query_SubNavigation, $TexITE_DB) or die(mysql_error()); $row_SubNavigation = mysql_fetch_assoc($SubNavigation); $totalRows_SubNavigation = mysql_num_rows($SubNavigation); } if ($_SESSION['Security'] > 0) { mysql_select_db($database_TexITE_DB, $TexITE_DB); $SecLevel = $_SESSION['Security']; $query_AdminNavigation = sprintf("SELECT * FROM navigation WHERE Sec <= 1 AND Root = '$submenu' ORDER BY `order`"); $AdminNavigation = mysql_query($query_AdminNavigation, $TexITE_DB) or die(mysql_error()); $row_AdminNavigation = mysql_fetch_assoc($AdminNavigation); $totalRows_AdminNavigation = mysql_num_rows($AdminNavigation); } ?>

2. class="current" >" target="">