How to send Mailalert -> New Order -> First Cutomer Order

[m.andrzejak]

Hello,

Can anybody tell me how can I simply add information on Mailalert - New Order e-mail is that First customer order?

I have SQL query:

SELECT c.id_customer, c.email, COUNT(o.id_order) AS Suma
FROM ps_customer AS c
LEFT JOIN ps_orders AS o ON o.id_customer = c.id_customer
WHERE c.id_customer = '.(int)$customer->id.'
GROUP BY c.id_customer

But how can I implement this into email?

[vekia]

you have to pass the result of this query to the variables array, which are attached to the email