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"; } } ?>
Become a Member
Why become a member of CAND?

The Form Below is Currently Disabled

Members of the Canadian Association of Nephrology Dietitians receive many benefits including:
  • Access to up-to-date information in the members area of our website
  • Membership in a network of other Nephrology Dietitians across Canada
  • Access to the Essential Guide for Renal Dietitians and any new updates 
  • Access to the CAND Kidney Friendly Cooking cookbook online
  • Invitation and a reduced fee at our conference
  • Newsletter
  • Be part of our online forum of questions, answers and comments from other members
To become a member of the CAND Network - join through Dietitians of Canada (you must be a member of DC to join CAND)

 




Entries marked with an asterisk* are required.

First Name*
Last Name*
 
Area of Practice*
Title
 
Hospital, Clinic or Organization*
Department, Unit No. or PO Box
 
Street Address
City*

Province*
Postal Code
 
Phone
Email*
 
Desired Username*
Desired Password*
 

Please enter the 3-digit number below.*