the file tpl_products_next_previous.php contains this code:
- Code: Select all
<?php
// only display when more than 1
if ($products_found_count > 1) {
It's not getting thru that 'if' statement...I searched Dev Tools for "$products_found_count" and it's pulled from a sql query in /includes/modules/product_prev_next.php:
- Code: Select all
$sql = "select p.products_id, p.products_model, p.products_price_sorter, pd.products_name, p.products_sort_order
from " . TABLE_PRODUCTS . " p, "
. TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " ptc
where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id= '" . (int)$_SESSION['languages_id'] . "' and p.products_id = ptc.products_id and ptc.categories_id = '" . (int)$current_category_id . "'" .
$prev_next_order;
$products_ids = $db->Execute($sql);
$products_found_count = $products_ids->RecordCount();
I'm just still confused how it works w/ the magic_seo_url.php commented out. Does the sql query build from the url? Are there any working examples that I can look at?
ZenCart Version 1.3.9d