function GetCategortyViewedTimesReport() { $q = db_query("select categoryID, name, viewed_times from " . CATEGORIES_TABLE . " where categoryID!=1 order by viewed_times DESC"); $data = array(); while ($r = db_fetch_row($q)) { $wayadd = ''; $way = catCalculatePathToCategoryA($r["categoryID"]); foreach ($way as $rail) { if ($rail['categoryID'] != 1) { $wayadd .= $rail['name'] . ' / '; } } $row = array(); $row["name"] = $wayadd . "<b>" . $r["name"] . "</b>"; $row["viewed_times"] = $r["viewed_times"]; $data[] = $row; } return $data; }
function catGetAppendedCategoriesToProduct($productID) { $q = db_query("select " . CATEGORIES_TABLE . ".categoryID as categoryID, name as category_name " . " from " . CATEGORIY_PRODUCT_TABLE . ", " . CATEGORIES_TABLE . " " . " where " . CATEGORIY_PRODUCT_TABLE . ".categoryID = " . CATEGORIES_TABLE . ".categoryID " . " AND productID = " . (int) $productID); $data = array(); while ($row = db_fetch_row($q)) { $wayadd = ''; $way = catCalculatePathToCategoryA($row["categoryID"]); $cway = count($way); for ($i = $cway - 1; $i >= 0; $i--) { if ($way[$i]['categoryID'] != 1) { $wayadd .= $way[$i]['name'] . ' / '; } } $row["category_way"] = $wayadd . "<b>" . $row["category_name"] . "</b>"; $data[] = $row; } return $data; }