Add new comment

Submitted by Martin on Wed, 08/30/2017 Permalink

Hello, 

could you please help me. 

want to add something like this:

(SELECT substring_index(substring_index(`shipping_custom_field`, '\{"6":"', -1), '\","', 1) FROM `".PREFIX."order`) AS test,
    order_id,
    CONCAT (`".PREFIX."order`.invoice_prefix,`".PREFIX."order`.invoice_no) AS invoice_no,
    telephone,
    SELECT total*currency_value AS order_total,
    currency_code,
    shipping_firstname, 
    shipping_custom_field,
    shipping_address_1,

etc...

but the first line doesn´t work:

(SELECT substring_index(substring_index(`shipping_custom_field`, '{"6":"', -1), '","', 1) FROM `".PREFIX."order`) AS test

how can I make it work in your file?

Thank you very much.

 

The content of this field is kept private and will not be shown publicly.

Markdown