thnx :wink:
got another problem now. when i try to acces the affiliaite_summary.php i get this error:
1054 - Unknown column 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS' in 'where clause'
select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from affiliate_sales a left join orders o on (a.affiliate_orders_id=o.orders_id) where a.affiliate_id = '1' and o.orders_status >= AFFILIATE_PAYMENT_ORDER_MIN_STATUS
[TEP STOP]
any thoughts?
thnx in advanced,
WizzarD