Quote:
|
Originally Posted by yamiya
Hi,
I love your code. But is there anyway to display the prices and SKU just as in Featured Product Box? Also how do I sort them according to Product Name?
Hope to get an answer for that.  |
For sorting by Product Name change:
PHP Code:
if ((empty($cat))&&(empty($products)))
{
//number spec. cat :)))
$spec_cat = "2";
$allproduct = array();
$allproduct = func_query ("SELECT * FROM $sql_tbl[products], $sql_tbl[products_categories] WHERE $sql_tbl[products].productid=$sql_tbl[products_categories].productid AND $sql_tbl[products].forsale='Y' $avail AND $sql_tbl[products_categories].categoryid='$spec_cat' ORDER BY $sql_tbl[products].product");
$smarty->assign("allproduct", $allproduct);
}