\n"; ConnectDB(); $top_text_color="#FFFFFF"; $top_bgcolor="#CA0000"; $bgcolor1="#FFE7CE"; $bgcolor2="#D9D9FF"; $bgcolor=$bgcolor1; $to_category=$category; $to_subcategory=$subcategory; $category =str_replace("%20", " ", $category); $subcategory =str_replace("%20", " ", $subcategory); //include("other/cart.php"); //echo "\n\n\n"; if ($command=='add2cart') { mysql_connect("$DBHost","$DBUser","$DBPass"); mysql_select_db("$DB"); if ($quantity=="" || $quantity==0) {$quantity=1;} mysql("$DB", "INSERT INTO $cart (id,sku,quantity,from_extra,item_size,date_in,aff_id,options) values ('$id','$sku','$quantity','$price_id','$item_size','$date_now','$aff_id','$options')"); echo "
Item Added To Cart\n"; $result=mysql_query("select quantity from $cart where id='$id'"); while ($row = mysql_fetch_row($result)) { $item_counter=$item_counter+$row[0]; } echo "\n"; if ($item_counter==1) { echo "You have $item_counter item in your cart.

"; } elseif ($item_counter>1) { echo "You have $item_counter items in your cart.

"; } echo "\n"; } echo "\n"; // Check if category has a subcategory $show_subcategory=0; if ($category!="" && $subcategory=="") { mysql_connect("$DBHost","$DBUser","$DBPass"); mysql_select_db("$DB"); $result=mysql_query("select * from $subcategories where category='$category'"); $row = mysql_fetch_row($result); if ($row[0]!="") { $show_subcategory=1; } } if ($show_subcategory==1) { // Show Subcategories echo "\n\n"; echo "
\n"; echo "

\n"; echo "

"; echo "Your are here: Home :: "; $result=mysql_query("select * from $categories where cat_id='$category'"); $row = mysql_fetch_row($result); echo "$row[1]"; echo "

"; echo "

\n"; echo "

\n"; if ($row[3]!="") { echo "\n"; } else { echo "

$row[1]

\n"; } echo "

\n"; echo "
\n"; if ($pos=='') { $pos=1; } $accross=4; $start_column=1; $max=6; $countto=$max+$pos-1; $i=1; mysql_connect("$DBHost","$DBUser","$DBPass"); mysql_select_db("$DB"); $result=mysql_query("select * from $subcategories where category='$category'"); //echo "\n\n\n\n"; echo "\n"; while ($row = mysql_fetch_row($result)) { if (($i>=$pos)&&($i<=$countto)){ if ($start_column==$accross) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; $start_column=1; $trow_done=0; } else { if ($start_column==1) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; $start_column=$start_column+1; $trow_done=1; } } $i++; } $category = ereg_replace("%20", " ", $category); $search = ereg_replace("%", " ", $search); if ($i>$countto) { echo " "; } if ($trow_done==1) { echo "\n"; } echo"

"; // echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo ""; echo "\n"; echo "

\n"; echo "

"; echo ""; echo "

"; echo "

\n"; echo "

$row[1]\n"; echo "

\n"; echo "

\n"; // //echo "\n"; //echo "

"; //echo ""; //echo "

\n"; //echo " $row[1]\n"; //echo "

\n"; //echo " \n"; echo "\n"; echo "

"; // echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "\n"; echo ""; echo ""; echo "\n"; echo "

\n"; echo "

"; echo ""; echo "

"; echo "

\n"; echo "

$row[1]\n"; echo "

\n"; echo "

\n"; // //echo "\n"; //echo "

"; //echo ""; //echo "

\n"; //echo " $row[1]\n"; //echo "

\n"; //echo " \n"; echo "\n"; echo "

"; $next=$countto+1; echo "More Selections"; echo "

\n"; //echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; // echo "

Change Category:

\n"; } else { if ($category=="foo") { include ("other/stair_lifts.php"); } elseif ($search=="search") { // Show Item List mysql_connect("$DBHost","$DBUser","$DBPass"); mysql_select_db("$DB"); // echo "\n\n"; // echo "

\n"; // echo "

\n"; // echo ""; // echo "Your are here: Home :: "; // $result=mysql_query("select * from $categories where cat_id='$category'"); // $row = mysql_fetch_row($result); // echo "$row[1]"; // if ($subcategory!="") { // $result3=mysql_query("select * from subcategory where id='$subcategory'"); // $row3 = mysql_fetch_row($result3); // echo " :: $row3[1]"; // } // echo ""; // echo ""; // echo "

\n"; // echo "

\n"; // echo "$row[1]\n"; // echo "

\n"; // echo "
\n"; if ($pos=='') { $pos=1; } $max=75; $countto=$max+$pos-1; $i=1; $result=mysql_query("select * from $items where sku like '%$keyword%' or name like '%$keyword%' or description_small like '%$keyword%' or description_large like '%$keyword%' or keywords like '%$keyword%' and item_active='1' order by price asc"); echo ""; echo "

\n"; while ($row = mysql_fetch_row($result)) { if ($row[14]==1) { if (($i>=$pos)&&($i<=$countto)){ echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $sku_id=$row[0]; $sku=$row[1]; echo "\n"; echo "\n"; echo "\n"; if ($row[10] !=""){ echo ""; } else { echo ""; } echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

"; echo "

\n"; echo "

"; echo "

"; echo "

\n"; echo "

"; echo "\n"; echo "

\n"; echo "$row[4]
\n"; if ($row[9]!=""||$row[9]!=0) { echo "SRP $$row[9]\n"; } //echo "More Info
\n"; if ($row[18]!=1) { # Use Which Price if ($row[8]==1) { echo"
Your Price : "; //echo ""; echo "$$row[9]"; //echo ""; echo "\n"; } else { if ($row[7]!="0.00") { echo"
Our Price : "; //echo ""; echo "$$row[7]"; //echo ""; echo "\n"; } } } elseif ($row[19]!="") { echo"
Click for info: "; echo "$$row[7]"; } else { $result2=mysql_query("select * from multi_price where sku='$sku'"); echo "
Select:"; echo "\n"; } echo "

\n"; echo "

"; echo "

\n"; echo "

\n"; echo "\n"; echo ""; $result4=mysql_query("select * from item_quick_specs where sku_id='$sku_id'"); while ($row4 = mysql_fetch_row($result4)) { echo ""; } echo "

Quick Specifications:
·	$row4[2]

"; echo "

\n"; // Rotate Background Colors //if ($bgcolor==$bgcolor1) {$bgcolor=$bgcolor2;} //else {$bgcolor=$bgcolor1;} $category = ereg_replace("%20", " ", $category); $search = ereg_replace("%", " ", $search); if ($i==$countto) { echo ""; $next=$countto+1; if ($category!=''){ $category = eregi_replace(" ", "%20", $category); $subcategory = eregi_replace(" ", "%20", $subcategory); echo "
List More Items..."; } echo ""; } echo"\n"; } $i++; } } echo "

\n"; if ($i==1) { echo "No matches for term: $keyword

\n"; } } else { // Show Item List mysql_connect("$DBHost","$DBUser","$DBPass"); mysql_select_db("$DB"); echo "\n\n"; echo "
\n"; echo "
"; echo "Your are here: Home :: "; $result=mysql_query("select * from $categories where cat_id='$category'"); $row = mysql_fetch_row($result); echo "$row[1]"; if ($subcategory!="") { $result3=mysql_query("select * from subcategory where id='$subcategory'"); $row3 = mysql_fetch_row($result3); echo " :: $row3[1]"; } echo ""; echo "
"; echo "
\n"; echo "\n"; echo "
\n"; if ($row[3]!="") { echo "\n"; } else { echo "
$row[1]
\n"; } if ($pos=='') { $pos=1; } $max=75; $countto=$max+$pos-1; $i=1; if ($brand!="") { $result=mysql_query("select * from $items where brand='$brand' and item_active='1' order by price asc"); } else { if ($subcategory!='') { $result=mysql_query("select * from $items where category='$category' and subcategory='$subcategory' and item_active='1' order by price asc"); } else { $result=mysql_query("select * from $items where category='$category' and item_active='1' order by price asc"); } } echo "

"; echo "

\n"; while ($row = mysql_fetch_row($result)) { if (($i>=$pos)&&($i<=$countto)){ echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $sku_id=$row[0]; $sku=$row[1]; echo "\n"; echo "\n"; echo "\n"; if ($row[10] !=""){ echo ""; } else { echo ""; } echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

"; echo "

\n"; echo "

"; echo "

\n"; echo "

"; echo "

\n"; echo "

"; echo "

\n"; echo "

"; echo "\n"; echo "

\n"; echo "$row[4]
\n"; if ($row[9]!="0.00"&&$row[9]!=0) { echo "MSRP $$row[9]
\n"; } //echo "More Info
\n"; /* if ($row[18]!=1) { # Use Which Price if ($row[8]==1) { echo"
Your Price : "; //echo ""; echo "$$row[9]"; //echo ""; echo "\n"; } else { if ($row[7]!="0.00") { echo"
Our Price : "; //echo ""; echo "$$row[7]"; //echo ""; echo "\n"; } } } elseif ($row[19]!="") { echo"
Click for info: "; echo "$$row[7]"; } else { $result2=mysql_query("select * from multi_price where sku='$sku'"); echo "
Select:"; echo "\n"; } */ echo "

\n"; echo "

"; echo "

\n"; echo "

\n"; echo "\n"; echo ""; echo "\n"; $result4=mysql_query("select * from item_quick_specs where sku_id='$sku_id'"); while ($row4 = mysql_fetch_row($result4)) { echo ""; } echo "

Quick Specifications:

·	$row4[2]

"; echo "

Categories:

\n"; echo "

\n"; } } //echo "\n"; echo "\n"; echo "
View Cart | "; echo "Continue Browsing

\n"; echo "
"; echo "\n"; ?> \n"; commonFooter(); ?>