Hmmm
Ich hab's jetzt so:
$sql = ("SELECT distinct
m.manufacturers_id,
m.manufacturers_name,
m.manufacturers_image
from ".TABLE_MANUFACTURERS." m,
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_TO_CATEGORIES." p2c
where m.manufacturers_id = p.manufacturers_id
and p.products_status = 1
and p.products_id = p2c.products_id
and p2c.products_id IN
(SELECT p2c.products_id from ".TABLE_PRODUCTS_TO_CATEGORIES." p2c where p2c.categories_id BETWEEN '".$c_start."' AND '".$c_end."')
".$fsk_lock."
".$group_check."
order by m.manufacturers_name");
if ((int)$_SESSION['customer_id'] == '1') {echo $sql;}
$manufacturers_query = xtDBquery($sql);
Als Ausgabe erhalte ich damit nur ...
SELECT distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from manufacturers m, products p, products_to_categories p2c where m.manufacturers_id = p.manufacturers_id and p.products_status = 1 and p.products_id = p2c.products_id and p2c.products_id IN (SELECT p2c.products_id from products_to_categories p2c where p2c.categories_id BETWEEN '11000' AND '11999') order by m.manufacturers_name
Ist doch bestimmt wieder nur ein Problem mit Semikolons, Anführungszeichen, oder Hochkommata
Mit Try and Error habe ich schon einige Variationen durch, aber leider haut's bei jedem Fehlversuch trotz Adminabfrage den Liveshop weg.
... ist das kompliziert, wenn man's nicht gelernt hat. Sorry, wenn ich mich da ein wenig dumm anstelle.
Werde gleich noch diese Variante testen (statt Anführungszeichen mit Hochkommata, auch in der Subselect Anweisung). Im Editor wird damit jedenfalls kein Fehler angezeigt
$sql = ('SELECT distinct
m.manufacturers_id,
m.manufacturers_name,
m.manufacturers_image
from ".TABLE_MANUFACTURERS." m,
".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_TO_CATEGORIES." p2c
where m.manufacturers_id = p.manufacturers_id
and p.products_status = 1
and p.products_id = p2c.products_id
and p2c.products_id IN
(SELECT p2c.products_id from '.TABLE_PRODUCTS_TO_CATEGORIES.' p2c where p2c.categories_id BETWEEN '.$c_start.' AND '.$c_end.')
".$fsk_lock."
".$group_check."
order by m.manufacturers_name');
... "leider" sind im Moment zu viele Kunden online.