snap-affiliates?

[ShockRaver]

anyone?

Hi,

in the account page i want to add a column to show the latest order status of the order.

in includes/modulespages/refferer_main/header_php.php i changed the sql statement to this:

select o.date_purchased, o.order_total, c.commission_paid, c.commission_rate, t.value, s.orders_status_id from zen_orders as o, zen_orders_total as t, zen_commission as c, zen_orders_status_history as s where c.commission_referrer_key = '**********' and o.orders_id = t.orders_id and o.orders_id = c.commission_orders_id and t.class = 'ot_shipping' and o.orders_id = s.orders_id GROUP BY s.orders_id order by s.orders_status_history_id ASC

But i think i didn't GROUP it well, because it always shows the order status of the latest order...

can someone help me with this?

Eelco