Add new comment

problem with a code in sql

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.

Your name

Email

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

Homepage

Notify me when new comments are posted

All comments

Replies to my comment

CAPTCHA

Math question 16 + 0 =

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