how to get database input into a oderemail ?

Thursday 02 February 2006 5:48:43 am

Hi all,

first at all, i have a userregisterform with a section for payment methods.
you can choose and this will be written into the database / table = ezorders as
a new xml tag ( <zahl>example</zahl>) in the data_text_1 field.

So for example a data_text_1 field contains this information :

<?xml version="1.0" encoding="UTF-8"?>
<shop_account>
<first-name>t</first-name>
<last-name>e</last-name>
<email>s.kamphoff@eye-systems.com</email>
<street1>s</street1>
<street2>t</street2>
<zip>1</zip>
<place>2</place>
<state></state>
<country>Deutschland</country>
<comment></comment>
<zahl>Vorkasse</zahl>
</shop_account>

My problem is how to get this input into the orderconfirmmail ?

Regards