0

I have MySql Query like this:

SELECT product_list.id AS listId,
       product_list.class AS listClass,
       product.prod_name AS prodName,
       product.prod_url AS prodUrl,
       product.prod_overview AS prodOverview,
       product_img.list_prod340x340 AS prodListImg,
       MIN(pricelist.price) AS price
  FROM (((product_list 
  JOIN product_img ON product_list.id = product_img.prod_list_id) 
  JOIN product     ON product_list.id = product.prod_list_id) 
  JOIN pricelist   ON product.id = pricelist.prod_id)
 GROUP BY listId, listClass, prodName, prodUrl, prodOverview, prodListImg
 ORDER BY product_list.id, price

I want to get result in JSON format, how can i get there?

Improve this question
2
  • Can you please reconsider why you needed those brackets within the part after the FROM clause ..? Commented Jul 10, 2022 at 7:03
  • dunno, just following the tutorial from w3school Commented Jul 10, 2022 at 7:57
Related questions
5
Multiple MySQL table to json_encode
0
PHP Join MySQL Tables, Output Formatted JSON
0
how to select mysql in multi table and mix in one json?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.