After the problems in the development of group by two fields must be the same to repeat so led to the date of payment type is not convenient to the page data will appear as pictures of

CodePudding user response:

CodePudding user response:

Upstairs is SQL according to the front page shows two date should be the following 2 to move up to show only a 2018-06-06

CodePudding user response:

Can you give a you want to display as a result, there is only one on June 6, how to deal with other fields,

CodePudding user response:

reference AHUA1001 reply: 3/f

can you give a you want to display as a result, there is only one on June 6, how to deal with other fields,

means the same date data merge payment types of data together into a data showed multiple payment types to understand

CodePudding user response:

Your code is pictures, can't paste, you can try to do so, not
First, delete line 26,
Second, the line 7 AS the content of the former, with GROUP_CONCAT (type ORDER BY type), type is your that type fields,
Replace the try, best paste the code after processing, images I here can't copy,

CodePudding user response:

What is with the platform? Interface is very good-looking!!!!!

CodePudding user response:

refer to 7th floor Chronostasis_ response:

what is the use of the platform? Interface is very good-looking!!!!!

layui

CodePudding user response:

Resolved thank you use column career change