0) {
$sql = "SELECT nav_name, nav_link, 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"];
$navparent_link = $row["nav_link"];
if ($projcat_id > 0) {
$sql2 = "SELECT projcat_id, projcat_name, projcat_link_desc FROM project_categories WHERE projcat_hide = 'N' ORDER BY projcat_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)) {
$projcat_id2 = $row2["projcat_id"];
$projcat_name2 = $row2["projcat_name"];
$projcat_link_desc2 = $row2["projcat_link_desc"];
if ($cfg_clean_urls) {
$href_link = $navparent_link_desc."/".$projcat_link_desc2;
} else {
$href_link = "projects_featured.php?projcatid=".$projcat_id2."&nv=".$nv_nav_parent_id;
}
if ($projcat_id2 != $projcat_id) {
print "
".$projcat_name2."![\"divider](\"images_sub/sidenav_divider.png\")
\n";
} else {
if ($proj_id == "") {
print "
\n";
$page_title = $projcat_name2;
} else {
print "
".$projcat_name2."\n";
$sql3 = "SELECT proj_id, proj_name FROM projects WHERE proj_projcat_id = '$projcat_id2' AND proj_featured = 'Y' AND proj_hide = 'N' ORDER BY proj_sequence";
$result3 = mysqli_query($conn,$sql3);
if (mysqli_num_rows($result3)>0) {
while ($row3 = mysqli_fetch_array($result3, MYSQL_ASSOC)) {
$proj_id3 = $row3["proj_id"];
$proj_name3 = $row3["proj_name"];
if ($proj_id3 != $proj_id) {
print " -
".$proj_name3."\n";
} else {
print "
\n";
}
}
}
}
}
}
print "
\n";
print "
![\"decorative](\"images_nav/sidenav_bot_shadow.png\")
\n";
}
} else {
$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 ($navchild_link_desc != "writer") { /* special code for wordpress blog link to folder 'writer' */
$href_link = $navparent_link_desc."/".$navchild_link_desc;
} else {
$href_link = $navchild_link_desc;
}
} else {
$href_link = $navchild_link;
}
}
if ($navchild_id != $nv) {
print "
".$navchild_name."\n";
} else {
print "
\n";
}
}
print "
\n";
print "
\n";
}
}
}
?>
NEWS
WEEDEN ENVIRONMENTS INC.® has been granted another patent on their Sprinkler System
News Categories
News Items
NEWS
Weeden Environments has recently been granted another patent that provides additional protection on their Weeden Sprinkler System and method of cooling and promoting physical activity of poultry.