we are using Opencart 126.96.36.199. we need to select with a query values inside a shell because the custom fields in OC are in a shell in a row in oc_orders table.
I would like to select in orders table the custom fields. the select command in MySql gives me all the data in shell.
I have in customer 4 custom fields mobile phone , VAT. company name and company profession
I want to select the order_id in MySQL and show me the mobile phone and VAT in different columns.
I want to have in my select command different columns.
for example for the data as follow the next table
sql command : select order_id , custom_field where order_id = 800
gives me this:
and I want to have this:
order_id|mobile phone | vat | company name | company profession
800 |6946066448 | 061336572 | \u03a6\u03c1\u03b1a\u03b3\u03ba\u03b9\u03b1 | \u0397\u03a1\u0391\u039a\u039b\u0395\u0399\u039f\u03a5
Also when we finish the query we need to transform the characters for example \u03a5 to greek characters
9 freelances font une offre moyenne de 33 € pour ce travail
Hi, We've got the right expertise in Opencart customization, API integration, bug fixing, and advanced development. Recently, we've worked on Custom Affiliate Commission Coupon for Opencart 2.3.x Here are a couple o Plus
Hello, Hope you are doing good! I’m Sas. I’ve carefully gone through your job posting. I am specialised in Web development industry for more than 9 years. I am very much interested in your project with all of yo Plus
Hello dear Hiring manager I have read your job post & being an expert Web developer, I offer myself for the job. I am having extensive knowledge and 5+ years of experience in PHP & WordPress website development u Plus