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"; } } ?>
About Us

The Canadian Association of Nephrology Dietitians was organized in 1975 as a subcommittee of the Canadian Society of Nephrology.

In 1991 we became a network of the Canadian Dietetic Association (now Dietitians of Canada). Our mission is to support Renal Dietitians in Canada in their provision of quality care to patients with renal disease.

We have regional representatives from across Canada.

This website serves as a portal for CAND members to share information, participate in discussion topics and to gain access to a Canada wide directory of renal dietitician professionals.

For more information on becoming a member of CAND, please click here.