laural4705

<ul id="navigation"> <!-- homepage --> <?php if ($_SESSION['id_service_link'] > '-1') { if ($_SESSION['id_language'] == '001' || $_SESSION['id_language'] == '003') { $lang_id_service = $_SESSION['id_service']; } else { $lang_id_service = $_SESSION['id_service_link']; } } else {$lang_id_service = $_SESSION['id_service']; } // QUERY NAV ITEMS - DIVISIONS $tsqlnav = "SELECT DISTINCT id_division AS id, id_division_slot AS slot, parent FROM [pwf].[dbo]. [assignments_content_active_service_div] WHERE id_svc = ? AND content_languages_list LIKE ? AND (parent ='' or parent is NULL) ORDER BY slot;"; // SET PARAMETERS AND OPTIONS $paramsnav = array($lang_id_service, '%'.$id_language.'%'); $optionsnav = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); // EXECUTE QUERY $stmtnav = sqlsrv_query($conn, $tsqlnav, $paramsnav, $optionsnav); if( $stmtnav === false ) { die( print_r( sqlsrv_errors(), true )); } // SET ROW COUNT $row_countnav = sqlsrv_num_rows( $stmtnav ); // NO ROWS if ($row_countnav === false) {echo "Error in retrieving row count."; } // ROW(S) FOUND - START elseif ($row_countnav > 0) { $div='0'; echo "<li><a href=\"https://www.advantageengagement.com/p_index.php?id_division=d00&id_module=m000\">". $_SESSION['d00']."</a></li>"; while( $row = sqlsrv_fetch_array( $stmtnav, SQLSRV_FETCH_ASSOC) ) { $parent = $row['parent']; $id_div = $row['id']; $id_div_slot = $row['slot']; echo "<li><a href=\"https://www.advantageengagement.com/p_division.php?id_division_slot=d $id_div_slot&id_division=d$id_div&id_div=d$id_div&id_module=m000\">".$_SESSION['d'.$row['id']]."</a><ul>"; $tsqlnav2 = "SELECT DISTINCT id_module AS id, id_module_slot AS slot, parent FROM [pwf].[dbo]. [assignments_content_active_service] WHERE id_svc = ? AND content_languages_list LIKE ? AND id_division = ? ORDER BY id;"; // SET PARAMETERS AND OPTIONS $paramsnav2 = array($lang_id_service, '%'.$id_language.'%', $id_div); $optionsnav2 = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); // EXECUTE QUERY $stmtnav2 = sqlsrv_query($conn, $tsqlnav2, $paramsnav2, $optionsnav2); if( $stmtnav2 === false ) { die( print_r( sqlsrv_errors(), true )); } // SET ROW COUNT $row_countnav2 = sqlsrv_num_rows( $stmtnav2 ); // NO ROWS if ($row_countnav2 === false) {echo "Error in retrieving row count."; } // ROW(S) FOUND - START elseif ($row_countnav2 > 0) { while( $row2 = sqlsrv_fetch_array( $stmtnav2, SQLSRV_FETCH_ASSOC) ) { $id_mod = 'm'.$row2['id']; echo "<li><a href=\"https://www.advantageengagement.com/p_module.php? id_division_slot=d$id_div_slot&id_division=d$id_div&id_module=$id_mod\">".$_SESSION[$id_mod]."</a></li>"; } } echo "</ul></li>"; } } OK, I finally finished rewriting my navigation and now it works much better.  I would still like to know how to wrap the code around the function (as above)...  but for now, here is the code that works in case it could help anyone else... of course, if anyone wants to offer improvements or has thoughts on this, please let me know