Antwort #15 am: 16. Januar 2016, 17:51:53
Hallo Torsten
Noch ein Nachtrag:
Den Query den ich gepostet habe musst Du mit diesem ersetzen,
$random_query = "SELECT p.products_id,
pd.products_name,
p.products_price,
p.products_tax_class_id,
p.products_image,
p2c.categories_id,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
cd.categories_name,
s.expires_date
FROM " . TABLE_PRODUCTS . " p
JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd
JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd
LEFT JOIN " . TABLE_SPECIALS . " s ON (p.products_id = s.products_id AND s.status = '1')
WHERE p.products_status = '1'
AND p.products_id = '".(int)$_SESSION['tracking']['products_history'][$random_last_viewed]."'
AND pd.products_id = '".(int)$_SESSION['tracking']['products_history'][$random_last_viewed]."'
AND p2c.products_id = '".(int)$_SESSION['tracking']['products_history'][$random_last_viewed]."'
AND pd.language_id = '" . $_SESSION['languages_id'] . "'
AND cd.categories_id = p2c.categories_id
".$group_check."
".$fsk_lock."
AND cd.language_id = '" . $_SESSION['languages_id'] . "'";
denn sonst werden auch Ablaufdaten für Produkte gezeigt, die gar keine Sonderangebote mehr sind.
Gruss
Hanspeter