I'm using the sebenza points module and want to be able to export that data on the customers. does anyone have knowledge about how to export this data, what needs to be done?
Thanks
--Kyle
Brandon MUS
02-13-07, 09:35 PM
What details do you need exported? Customer name, email and points?
SELECT
CONCAT(s01_Customers.ship_fname, ' ', s01_Customers.ship_lname) AS ship_fullname
, s01_Customers.ship_email
, s01_SS_POINTS_cust.total
FROM
s01_Customers
INNER JOIN
s01_SS_POINTS_cust
ON
s01_Customers.id = s01_SS_POINTS_cust.cust_id
vBulletin® v3.7.4, Copyright ©2000-2009, Jelsoft Enterprises Ltd.