DATE_FORMAT udtræk på en DATETIME

det skulle jeg da mene - virker det ikke ?

Måske du har en fejl andet sted i dit udtræk. Prøv at vise hele sætningen.

$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, DATE_FORMAT(date_purchased, '%d-%m-%Y') AS invoice_date, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

:)

Hvis du lige sætter en "or die()" på, kan vi se hvad fejl du får.

$order_query = tep_db_query("select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, DATE_FORMAT(date_purchased, '%d-%m-%Y') AS invoice_date, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'") or die(mysql_error());

Udover det, behøver du ikke int parse $order_id, da forespørgelsen sendes som en streng.

Har løst det på en anden måde. Ved ikk lige hvad den int er god for. Det er en del af osCommerce, så lidt uoverskueligt :)

Men min løsning var en oscommerce programeret funktion.

Hilsen Thomas

Lukker