Antwort #3 am: 13. Dezember 2010, 23:02:40
So es hat geklappt habe den Fehler!
/*
$customers_query_raw = "select
c.account_type,
c.customers_id,
c.customers_cid,
c.customers_vat_id,
c.customers_vat_id_status,
c.customers_lastname,
c.customers_firstname,
c.customers_email_address,
a.entry_country_id,
c.customers_status,
c.member_flag,
ci.customers_info_date_account_created
from
".TABLE_CUSTOMERS." c ,
".TABLE_ADDRESS_BOOK." a,
".TABLE_CUSTOMERS_INFO." ci
Where
c.customers_id = a.customers_id
and c.customers_default_address_id = a.address_book_id
and ci.customers_info_id = c.customers_id
".$search."
group by c.customers_id
".$sort;
*/
$customers_query_raw = "select
c.account_type,
c.customers_id,
c.customers_cid,
c.customers_vat_id,
c.customers_vat_id_status,
c.customers_lastname,
c.customers_firstname,
c.customers_email_address,
a.entry_country_id,
c.customers_status,
c.member_flag,
ci.customers_info_date_account_created
from
".TABLE_CUSTOMERS." c ,
".TABLE_ADDRESS_BOOK." a,
".TABLE_CUSTOMERS_INFO." ci
Where
c.customers_id = a.customers_id
and c.customers_default_address_id = a.address_book_id
and ci.customers_info_id = c.customers_id
".$search."
".$sort;
anscheinend ist davor der PHP-Befehl doppelt drinnen, aber einmal ausgeklammert. Weiß nicht warum, aber es klappt wenn ich es unten auch einfüge.