$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
from
" . TABLE_PRODUCTS . " p,
" . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd
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'] . "'";
In dem Query muss die Tabelle gejoint werden in der das Datum drinsteht.
So etwa:
$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,
" . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd,
" . TABLE_SPECIALS . " s
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'] . "'";
Dann wird das abgefragt:
$random_query = xtDBquery($random_query);
$random_product = xtc_db_fetch_array($random_query, true);
Und das Array $random_product sollte das Datum enthalten.
Lass mal ausgeben mit
var_dump($random_product['expires_date']); damit wir sehen was da überhaupt drin ist .... ob das noch formatiert oder konvertiert werden muss.