View Single Post
  #4  
Old 11-01-2009, 05:33 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default Re: order items export

Not sure how 4.1.12 is, this code is from 4.2.1
include/import_orders.php
Code:
if ($single_mode || AREA_TYPE == 'A') { $row = func_query_first("SELECT * FROM $sql_tbl[orders] WHERE orderid = '$id'"); } else { $row = func_query_first("SELECT $sql_tbl[orders].* FROM $sql_tbl[orders], $sql_tbl[order_details] WHERE $sql_tbl[orders].orderid = '$id' AND $sql_tbl[orders].orderid = $sql_tbl[order_details].orderid AND $sql_tbl[order_details].provider = '$login'"); }

you can change it like this and see if it works for you
Code:
# if ($single_mode || AREA_TYPE == 'A') { # $row = func_query_first("SELECT * FROM $sql_tbl[orders] WHERE orderid = '$id'"); # } else { $row = func_query_first("SELECT $sql_tbl[orders].* FROM $sql_tbl[orders], $sql_tbl[order_details] WHERE $sql_tbl[orders].orderid = '$id' AND $sql_tbl[orders].orderid = $sql_tbl[order_details].orderid AND $sql_tbl[order_details].provider = '$login'"); # }
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote