Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Five5
Five5
I am using the product registration functionality, and want to use custom fields to retrieve pertinent information from the users tax invoice. But as my SQL skill is non-existent, I was wondering if someone could assist.
 
Can anyone draft an SQL statement (which I will put in the custom field details) to do the following:
 
Retrieve from table va_orders_items
the following field order_id
for currently logged in user.
 
Is this possible, especially the part about retrieving information for logged in user?