|
|
|
|
1)) $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS;
$rows = 0;
$products_query_raw = "select p.products_id, pd.products_name, pd.products_viewed, l.name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_LANGUAGES . " l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC";
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_REPORTS, $products_query_raw, $products_query_numrows);
$products = $db->Execute($products_query_raw);
while (!$products->EOF) {
// only show low stock on products that can be added to the cart
if ($zc_products->get_allow_add_to_cart($products->fields['products_id']) == 'Y') {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
$cPath = zen_get_product_path($products->fields['products_id']);
?>
| fields['products_id']; ?> |
fields['products_id']) . '">' . $products->fields['products_name'] . ' (' . $products->fields['name'] . ')'; ?> |
fields['products_viewed']; ?> |
MoveNext();
}
?>
|
| display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_REPORTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?> |
display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_REPORTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?> |
|
|
|