Hi @@All,
the last posting is some month ago, but actual I'm also intersted how to export the "iso_code_3" from table "countries" into the csv-file.
I already tried to modifiy one of the queries in the exportorders.php to:
// -------------------- QUERIES 0 ------------------------------------//
//COUNTRIES nach Iso_Code_3 durchsuchen
$countries = tep_db_query("select countries_iso_code_3 from " . TABLE_COUNTRIES . "
where countries_name = " . $Land);
//$row_orders_status_history = tep_db_fetch_array($comments);
while($row_countries = mysql_fetch_array($countries)) {
// end //
$Land1 = filter_text($row_countries['countries_iso_code_3']);
}
"$Land" is defined in this line:
$Land = str_replace("(48 Contiguous Sta", "", $row_orders["delivery_country"]);
For my undersatanding it might be correct and should work, but whan I click to the export button I get the error:
1054 - Unknown column 'Deutschland' in 'where clause'
select countries_iso_code_3 from countries where countries_name = Deutschland
[TEP STOP]
Has anybody an idea, where I made the mistake?
Many thanks in advance
Best regards from Germany
Michael