Hi all,

I'm using Community Builder 2.0.10 with Hikashop Business 2.5.0.

What I'm trying to do is load a Community Builder custom field I added to the user profile, into the subject line of my Hikashop "new order" email.

At first I was trying to do this via the Hikashop language string, but over on the Hikashop forums I was told I likely need to use a MySQL query to call this field in the email.

So, after looking up how to write a MySQL query, and even searching on these forums, I'm still kind of stumped.

Can anyone tell me the best way to accomplish this? Even if it's not a database query. Thanks for any help.