Low shipping cost with our Virtual Herb Bags. Add upto 8 units
of selected products to your order at one low shipping price of just $3.50.
EOD;
break;
default:
} // end switch, special category query
}
if(!empty($_GET[what]))
{
$q_what=escape_string($_GET[what]);
$query[] = " (ItemName like '%$q_what%' or ItemDesc like '%$_GET[what]%') ";
}
if(!empty($_GET[CategoryID]))
{
$q_cat_id=intval($_GET[CategoryID]);
//-->@mod Jul 26, 2016
//-->@extra category multi-select
$query[] = " ((ItemCategory = '$q_cat_id') OR ( FIND_IN_SET($q_cat_id,prod_extra_category) >0 )) ";
}
if(!empty($_GET[SubcategoryID]))
{
$q_subcat=intval($_GET[SubcategoryID]);
$query[] = " ItemSubcategory = '$q_subcat' ";
}
if(!empty($query))
{
$my_query = implode(" and ", $query);
$my_query = " where $my_query";
}
if(!empty($_GET[ord1]))
{
$q_ord=escape_string($_GET[ord1]);
$order_by = " order by $q_ord ";
}
else if($q_spcl == 'vhb') {
$order_by = " ORDER BY ItemName ASC ";
}
else
{
$order_by = " order by ItemID DESC";
}
//show the catalog content
//$q1 = "select isFree, ItemID, ItemName, ItemCategory,ItemPrice,ItemImageURL,ItemDesc from dd_catalog $my_query $order_by limit $Start, $ByPage";
//--> get full data from catalog
$q1 = "select * from dd_catalog $my_query $order_by limit $Start, $ByPage";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) > '0')
{
$product_cat=$_GET[CategoryID];
$q2="select CategoryName from dd_categories where CategoryID='$product_cat'";
$r2=mysql_query($q2);
if(($r2) && mysql_num_rows($r2))
{
$a2=mysql_fetch_array($r2);
$result_title=''.$a2[CategoryName].'
'; $seo_page_title=seo_format_title($a2); } // end if $col = $tcs_resultRow1; while($a1 = mysql_fetch_array($r1)) { $x_item_id=intval($a1['ItemID']); if($col == $tcs_resultRow1) { $col = $tcs_resultRow2; } else { $col = $tcs_resultRow1; } /* //--> item price $price=($a1[isFree]) ? '0.00':$a1[ItemPrice]; if($price) { $price_tag='
Price: '.$aset[currency_sign].$price.'
';
}
else
{
$price_tag='
Price: '.$aset[currency_sign].'0.00 Free
';
} // end if, price
*/
//--> get price structure table
$price_tag=get_price_struct_table($a1,false,true);
//--> item description
$desc=$a1[ItemDesc];
if($desc)
{
$desc=getExcerpt($desc,0,500);
$desc_tag='Description:
'.$desc.'
';
} // end if, desc
//--> item image
$img_url=$a1[ItemImageURL];
if($img_url)
{
//--> get fixed width image
$img_tag=fixedWidthImage($img_url,100,1,'',$a1[ItemName]);
}
else
{
$img_tag=fixedWidthImage($site_url.'/images/no_image.gif',100,1,'',$a1[ItemName]);
} // end if, item image
//--> no image border
$img_tag=str_replace('
';
}
else
{
//--> Paid
$prod_inv_instock=intval($a1['product_in_stock']);
$prod_inv_qty=intval($a1['product_inv_qty']);
if( ($prod_inv_instock <=0) || ($prod_inv_qty <=0) ) {
//-->@don't show add to cart button
$add_cart_link='';
} else {
//$add_cart_link='
';
$add_cart_link='';
} // end if, show add to cart button
} // end if
$prod_link=seo_product_url($a1[ItemID]);
$result_rows .= "$a1[ItemName]
{$desc_tag} {$price_tag} {$add_cart_link}
';
$result_rows .= "$a1[ItemName]
{$desc_tag} {$price_tag} {$subscribe_link}| '.$PrevPageLink.' | ';
$NextPrev .= "
\n"; $NextPrev .= ' | '.$NextPageLink.' |
| '.$PrevPageLink.' | ';
$NextPrev .= "
\n"; $NextPrev .= ' | '.$NextPageLink.' |