| | FAQ | Help

Keyword Product Code

1-800-658-8788 Call ABC Office
Speak With one of our Experts Today!

by Category


by Manufacturer


Siteseal
>

Site Map


MemberOf $querymo = 'SELECT Category.MemberOf, Category.Description, Category.AltMemberOf, Category.Supply FROM Category WHERE (((Category.Discon_YN)=0) AND ((Category.SiteName)="ABC Site") AND (Category.RegularIdx<>0) AND ((Category.OneLevelUp)="'.$datamc["MainCat"].'"));'; $resultmo = mysql_query($querymo); while($datamo = mysql_fetch_array($resultmo)) { // assign mcLinks link and anchor text $MemberOf = ($datamo['AltMemberOf']!=null && $datamo['AltMemberOf']!="") ? $datamo['AltMemberOf'] : $datamo['MemberOf']; $MCLinks[$mainCat][$c]["PageName"] = $MemberOf; $MCLinks[$mainCat][$c]["AnchorText"] = $datamo["Description"]; ++$c; } // mcLinks Part 2 - Main Category - > Intermediate $queryi = 'SELECT MainCatInfo.AnchorText, MainCatInfo.MainCat, MainCatInfo.AltMainCat FROM MainCatInfo WHERE (((MainCatInfo.SiteName)="ABC Site") AND ((MainCatInfo.OneLevelUp)="'.$datamc['MainCat'].'")) AND (MainCatInfo.MainCat Not Like MainCatInfo.OneLevelUp) ORDER BY MainCatInfo.AnchorText;'; $resulti = mysql_query($queryi) or die('intermediate query failed'); while($datai = mysql_fetch_array($resulti)) { $d=0; // 3 clicks deep // assign mcLinks link and anchor text $intermediate = ($datai['AltMainCat']!=null && $datai['AltMainCat']!="") ? $datai['AltMainCat'] : $datai['MainCat']; $MCLinks[$mainCat][$c]["PageName"] = $intermediate; $MCLinks[$mainCat][$c]["AnchorText"] = $datai['AnchorText']; // iLinks - Main Category - > Intermediate - > MemberOf $querycat = 'SELECT Category.MemberOf, Category.OneLevelUp, Category.Description, Category.AltMemberOf, Category.Supply FROM Category WHERE (((Category.OneLevelUp)="'.$datai["MainCat"].'") AND (Category.SiteName = "ABC Site") AND ((Category.Discon_YN)=0)) ORDER BY Category.MemberOf;'; $resultcat = mysql_query($querycat); while($datacat = mysql_fetch_array($resultcat)) { // assign iLinks link and anchor text $MemberOf = ($datacat['AltMemberOf']!=null && $datacat['AltMemberOf']!="") ? $datacat['AltMemberOf'] : $datacat['MemberOf']; $ILinks[$intermediate][$d]['PageName'] = $MemberOf; $ILinks[$intermediate][$d]["AnchorText"] = $datacat["Description"]; ++$d; } ++$c; } ++$b; } // Create accordian divs foreach($MainCats as $MainCat) { echo '

'.$MainCat['AnchorText'].'

'; // level 1, MainCats foreach($MCLinks[($MainCat["PageName"])] as $mcLink) { $cssClass = (isset($ILinks[($mcLink["PageName"])])) ? "intermediate" : "memberOf"; echo '
'; // Level 2, Intermediates echo ''.$mcLink["AnchorText"].''; if(isset($ILinks[($mcLink["PageName"])])) { foreach($ILinks[($mcLink["PageName"])] as $iLinks) { echo ''; // Level 3, MemberOfs } } echo '
'; // end of intermediate/index div, level 2 } echo '
'; // main MainCat Links Div, level 1 } ?>



800-658-8788 Or: 866-380-9222

Local Phone: 801.927.3020

Fax Number: 801.927.3037

8:00am - 5:00pm (MST) M-F

Email ABC Office
Company Info ABC Office Blog ABC Office Facebook Page ABC Office Google+ Page
Home   |   Site Map   |   About Us   |   Contact Us   |   Policies 39 ABC Office YEARS Site Secured by Godaddy.com All Major Credit Cards Welcome! ShopSite Cart Amazon Star Rating