0) { $sql = "SELECT nav_name, nav_link_desc FROM navigation WHERE nav_id = '$nv_nav_parent_id' ORDER BY nav_sequence"; $result = mysqli_query($conn,$sql); $row = mysqli_fetch_array($result, MYSQL_ASSOC); $navparent_name = $row["nav_name"]; $navparent_link_desc = $row["nav_link_desc"]; $sql2 = "SELECT nav_id, nav_name, nav_link, nav_link_desc, nav_pl_id FROM navigation WHERE nav_parent_id = '$nv_nav_parent_id' AND nav_hide != 'Y' ORDER BY nav_sequence"; $result2 = mysqli_query($conn,$sql2); if (mysqli_num_rows($result2)>0) { print "
\n"; print "
\n"; print "
".$navparent_name."
"; print "
\n"; while ($row2 = mysqli_fetch_array($result2, MYSQL_ASSOC)) { $navchild_id = $row2["nav_id"]; $navchild_name = $row2["nav_name"]; $navchild_link = $row2["nav_link"]; $navchild_link_desc = $row2["nav_link_desc"]; $nav_pl_id = $row2["nav_pl_id"]; if (substr($navchild_link,0,11) == "product.php") { /* this section just in case the sublink is the main link to the shopping cart */ $sql23 = "SELECT prodcat_id, prodcat_name FROM product_categories WHERE prodcat_prodline_id = '$nav_pl_id' AND prodcat_hide = 'N' ORDER BY prodcat_sequence"; $result23 = mysqli_query($conn,$sql23); if (mysqli_num_rows($result23)>0) { while ($row23 = mysqli_fetch_array($result23, MYSQL_ASSOC)) { $prodcat_id23 = $row23["prodcat_id"]; $prodcat_name23 = $row23["prodcat_name"]; $sql24 = "SELECT prod_id, prod_url_desc FROM products WHERE prod_prodcat_id = '$prodcat_id23' AND prod_hide != 'Y' ORDER BY prod_sequence"; $result24 = mysqli_query($conn,$sql24); if (mysqli_num_rows($result24)>0) { while ($row24 = mysqli_fetch_array($result24, MYSQL_ASSOC)) { $prod_id24 = $row24["prod_id"]; $prod_url_desc24 = $row24["prod_url_desc"]; $link_query = BuildLinkQuery($navchild_id, "", $prodcat_id23, $prod_id24, ""); break; } } break; } } if ($cfg_clean_urls) { $href_link = $prod_url_desc24."/".$link_query; } else { $href_link = $navchild_link."?product_description=".$prod_url_desc24."&product_query=".$link_query; } } else { if ($cfg_clean_urls) { /* if ($navparent_link_desc != $navchild_link_desc) { $href_link = $navparent_link_desc."/".$navchild_link_desc; } else { $href_link = $navchild_link_desc; } commented out by gw:2013-10-30 sublinks must have form like 'contact-us/contact-us' if main link has same name as sub-link */ $href_link = $navparent_link_desc."/".$navchild_link_desc; } else { $href_link = $navchild_link; } } if ($navchild_id != $nv) { print "".$navchild_name."

\n"; } else { print "\n"; } if (substr($navchild_link,0,21) == "projects_featured.php" && $proj_id > 0) { /* this section just in case the sublink is the main link to a list of projects */ $projcat_name7 = $navchild_name; $sql7 = "SELECT projcat_id FROM project_categories WHERE projcat_name = '$projcat_name7' AND projcat_hide = 'N'"; $result7 = mysqli_query($conn,$sql7); $row7 = mysqli_fetch_array($result7, MYSQL_ASSOC); $projcat_id7 = $row7["projcat_id"]; if ($projcat_id7 == $projcat_id) { $sql8 = "SELECT proj_id, proj_name FROM projects WHERE proj_projcat_id = '$projcat_id7' AND proj_featured = 'Y' AND proj_hide = 'N' ORDER BY proj_sequence"; $result8 = mysqli_query($conn,$sql8); if (mysqli_num_rows($result8)>0) { while ($row8 = mysqli_fetch_array($result8, MYSQL_ASSOC)) { $proj_id8 = $row8["proj_id"]; $proj_name8 = $row8["proj_name"]; print " - ".$proj_name8."

\n"; } } } } } print "
\n"; } } ?>
Resources


Dietitians of Canada
Dietitians of Canada provides leadership and supports it over 5,000 members to promote health and well being through expertise in food and nutrition. We serve Canadians by maintaining high professional standards, advocating for sound public policy that promotes health, and providing trusted evidence-based nutrition information you can use.

The Renal Pharmacists Network
The renal pharmacists network has been in existence since 1996. Plans are under way to join with renal pharmacists from across Canada. Their mission is to enhance the quality of PC for patients along the continuum of renal insufficiency.

Canadian Association of Nephrology Social Workers
Nephrology social workers provide a wide range of services directly to persons with Chronic Kidney Disease and their families including counseling, support, education, and resource identification

Canadian Society of Nephrology
The Canadian Society of Nephrology is a society of physicians and scientists specializing in the care of people with kidney disease, and in research related to the kidney and kidney disease.

Canadian Association of Nephrology Nurses and Tech
Our Association is a voluntary not-for-profit organization dedicated to serving the needs of our members. Our primary purpose as set out in the Bylaws is to promote the dissemination of knowledge amongst those involved in the care of patients with renal disease.