if ($subcat2 == "") { echo "If you're looking for the right tools for your home or business, we have your needs covered. Power tools? Lathes? Hand held drills? Be sure to check out our extensive selection of home and business tools. Whether you need something for yourself or a gift for someone else, you're sure to find what you are looking for at House of Tools."; }
if (($subcat2) && ($subcat3 == "") && ($page == "")) { echo " $display_subcat2You're looking in the $display_subcat2 department. We have thousands of products available to help make your life easier in your business or home. Buy $year equipment today with House of Tools. Shopping online has never been easier."; }
if (($subcat2) && ($subcat3 == "") && ($page)) { echo "Page $page of the $display_subcat2 department. We have thousands of products available to help make your life easier in your business or home. Buy $year equipment today with House of Tools. Shopping online has never been easier."; }
if (($subcat3) && ($subcat4 == "") && ($page == "")) { echo "$name$name in the $display_subcat2 category. No matter what size the project or how much use you expect out of your equipment, we carry what you need. Buy $year equipment today with House of Tools."; }
if (($subcat3) && ($subcat4 == "") && ($page)) { echo "Page $page of the $display_subcat3 section in the $display_subcat2 category. No matter what size the project or how much use you expect out of your equipment, we carry what you need. Buy $year equipment today with House of Tools."; }
if (($subcat4) && ($subcat5 == "") && ($page == "")) { echo "The $display_subcat3 section in the $display_subcat2 category. House of Tools has everything you need in the $display_subcat2 and $display_subcat3 department. Shopping online is easy with House of Tools."; }
if (($subcat4) && ($subcat5 == "") && ($page)) { echo "Page $page of the $display_subcat4 section in the $display_subcat3 category. House of Tools has everything you need in the $display_subcat2 and $display_subcat3 department. Shopping online is easy with House of Tools."; }
if ($subcat5) { echo "Page $page of the $display_subcat4 section in the $display_subcat3 category. House of Tools has everything you need in the $display_subcat2, $display_subcat3, and $display_subcat4 department. Shopping online is easy with House of Tools."; }
?>
|
|
if ($subcat2 == "") {
$count =0;
echo "";
if ($count == "0") { echo ""; }
$query = "select distinct MerchantCategory from hardwareworld order by MerchantCategory asc";
$query2 = mysql_query($query) or die(mysql_error());;
while ($query3 = mysql_fetch_array($query2)) {
$count++;
$displaycat = $query3['MerchantCategory'];
$displaycat = str_replace("_"," ",$displaycat);
$displaycat = str_replace('"',"",$displaycat);
$urlcat = str_replace(" ","_",$displaycat);
if (($displaycat == "") || ($displaycat == "Category")) { $count = $count-1; } else {
echo "$displaycat | ";
if ($count == "2") { echo " "; $count =0; }
} }
echo "
";
}
?>
if (($subcat2) && ($subcat3 == "")) {
echo " Navigation: Home ";
$query = "select ProductID, Name, Thumbnail, Price, MerchantCategory, ShortDescription, Description, Link, Status from hardwareworld where MerchantCategory like '%$display_subcat2%'";
$query2 = mysql_query($query) or die ("Unable to Select #1");
echo "
";
while ($query3 = mysql_fetch_array($query2)) {
$id = $query3['ProductID'];
$name = $query3['Name'];
$name = str_replace('"','',$name);
$description = $query3['ShortDescription'];
$longdesc = $query3['Description'];
$imageurl = $query3['Thumbnail'];
$imageurl = str_replace('"',"",$imageurl);
$imageurl = str_replace("'","",$imageurl);
$title = $query3['Name'];
$title = str_replace('"',"",$title);
$link = $query3['Link'];
$link = str_replace('"',"",$link);
$link = str_replace("'","",$link);
$link = str_replace("","",$link);
$link = str_replace("priframe","product",$link);
$price = $query3['Price'];
$instock = $query3['Status'];
echo " $name | Product# $id Selling for $$price ";
echo " | ";
}
echo " ";
} //end subcat2
?>
if ($subcat3) {
echo "
Navigation: Home ";
echo " >> Tool Section";
echo " >> $display_subcat2 >>";
$count = 1;
$query = "select ProductID, Name, bigImage, Price, MerchantCategory, ShortDescription, Description, Link, Status from hardwareworld where ProductID='$subcat3'";
$query2 = mysql_query($query) or die ("Unable to Select #1");
echo "
";
while ($query3 = mysql_fetch_array($query2)) {
$id = $query3['ProductID'];
$name = $query3['Name'];
$name = str_replace('"','',$name);
$description = $query3['ShortDescription'];
$description = str_replace('"','',$description);
$longdesc = $query3['Description'];
$longdesc = str_replace('"','',$longdesc);
$imageurl = $query3['bigImage'];
$imageurl = str_replace('"',"",$imageurl);
$imageurl = str_replace("'","",$imageurl);
$title = $query3['Name'];
$title = str_replace('"',"",$title);
$link = $query3['Link'];
$link = str_replace('"',"",$link);
$link = str_replace("'","",$link);
$link = str_replace("","",$link);
$link = str_replace("priframe","product",$link);
$price = $query3['Price'];
$Status = $query3['Status']; $Status = str_replace('"','',$Status);
echo " Buy Today! | $name
$longdesc Stock Status: $Status Product# $id Our Price: $$price | ";
}
echo " ";
} //end of subcat3
?>
|
|