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"; } } ?>
Privacy Statement

Canadian Association of Nephrology Dietitians - Privacy Policy

In the context of conducting business and services, the Canadian Association of Nephrology Dietitians makes the following commitment:

1) The Canadian Association of Nephrology Dietitians will collect client information only with the client's consent and for the purpose(s) for which the client has given consent.

2) All client information and business transacted with the association will be safeguarded by security measures and will not be sold, rented or communicated in the form of customer lists or by any other means.

3) The Canadian Association of Nephrology Dietitians endeavors to respond to inquiries and concerns in a diligent fashion.  

Contact Information:

Concerns, questions or inquiries regarding the Canadian Association of Nephrology Dietitians privacy policies or procedures should be directed to:

The Canadian Association of Nephrology Dietitians
Attention: June Martin
15 North Queen St., #102
Toronto, Ontario, Canada
M8Z 6C1
Phone: 416.850.3589

Email: June Martin