Antwort #3 am: 16. Mai 2012, 09:22:12
Unabhängig davon, ob es in einer php-Datei steht findet dein Problem auf der MySQL-Ebene statt, da dir MySQL erst gar nicht die Datensätze zurückgibt, die du eigentlich willst.
$orders_query = xtc_db_query("SELECT
o.orders_id,
o.date_purchased,
o.delivery_name,
o.delivery_country,
o.billing_name,
o.billing_country,
ot.text as order_total,
s.orders_status_name,
t.ortra_order_id, t.ortra_parcel_id
FROM (".TABLE_ORDERS." o,
".TABLE_ORDERS_TOTAL." ot,
".TABLE_ORDERS_STATUS." s)
LEFT OUTER JOIN
".TABLE_ORDERS_TRACKING." t
ON
t.ortra_order_id = o.orders_id
WHERE o.customers_id = '".(int) $_SESSION['customer_id']."'
and o.orders_id = ot.orders_id
and ot.class = 'ot_total'
and o.orders_status = s.orders_status_id
and s.language_id = '".(int) $_SESSION['languages_id']."'
ORDER BY orders_id desc limit 3");