Hallo Simon,
ich bin an dem Thema auch sehr interessiert.
Bevor jetzt alle schimpfen, dass man im Template die DB nicht so abfragen soll: Hab zu dem Thema sonst nichts besseres gefunden.
Daher habe ich das Ganze über das Knie gebrochen bei einer Variante aus externer Tabelle:
PHP-Code:
<?php
$subbadubba_id=$this->raw['id'];
$this->import('Database');
$objwasduwillst = $this->Database->execute
("
SELECT
mm_externetabelle.name AS mm_name,
mm_externetabelle.id AS mm_id,
mm_externetabelle.shortdescription AS mm_description,
mm_externetabelle.main_picture AS mm_picture,
tl_iso_product.variantenname AS iso_product_variante,
tl_iso_product.published AS iso_product_published,
tl_iso_product.pid AS iso_product_pid,
tl_iso_product.id AS iso_product_id,
tl_iso_product_pricetier.price AS iso_pricetier_price,
tl_iso_product_pricetier.pid AS iso_pricetier_pid,
tl_iso_product_price.id AS iso_price_id,
tl_iso_product_price.pid AS iso_price_pid
FROM
mm_externetabelle,
tl_iso_product,
tl_iso_product_pricetier,
tl_iso_product_price
WHERE mm_externetabelle.id = tl_iso_product.variantenname
AND tl_iso_product.pid = $subbadubba_id AND tl_iso_product.published ='1'
AND tl_iso_product_price.pid = tl_iso_product.id
AND tl_iso_product_price.id = tl_iso_product_pricetier.pid
ORDER BY tl_iso_product_pricetier.price ASC
");
while ($objwasduwillst->next())
{
$var_mm_name = $objwasduwillst->mm_name;
echo $var_mm_name; // und alles was du noch ausgeben willst
}
?>
Vielleicht hat ja jemand eine bessere Idee.
Gruß Hauge
Lesezeichen