Hello-
I have a nagging issue. For some reason, i cannot get this code to work, despite the fact that the tables contain the columns referenced in the query. Below is the error I get:
The query failed
· errorno=1054
· error=Unknown column 'shipping_address' in 'on clause'
The query:
SELECT order_detail.id as order_id
,user_name
,item_total
,tax_total
,order_total
,shipping_total
,handling_total
,payer_id
,order_desc
,shipping_address
,billing_address
,status
,date_placed
,first_name
,last_name
,company
,email
,order_item.quantity as item_quantity
,item.id as item_id
,item.name as item_name
,item.desc as item_desc
,item.amount as item_amount
,item.tax as item_tax
,item.weight as item_weight FROM order_detail
,order_item INNER JOIN address ON (address.id=shipping_address)INNER JOIN address AS billing ON (billing.id=billing_address)INNER JOIN item ON (order_item.order_id=order_id) AND (item.id=order_item.item_id) WHERE user_name='wyl79787lb77g87'
I'm running:
PHP Version 5.1.4-pl0-gentoo
I'm getting kindof desperate...clock is ticking. Thanks in advance.
