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.
CAPTCHA
9 + 6 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Protected by Spam Master