Welcome Guest, Not a member yet? Register   Sign In
display data from the database (summarizes data)
#5

(This post was last modified: 04-22-2019, 04:38 AM by DELE.)

Example: See the table 'income_user' => '00002' the result I want is like this.

ID               NAMA             INCOME/COUNTRY           TOTAL SALES             TOTAL INCOME
00001
00002          -                       4US, 1PH                           5                                   $ 53.00
00003

Information :
INCOME/COUNTRY = the result of merging 'income_country' based on 'income_user' and summed and separated by country.
TOTAL SALES = total sales from all countries (4US + 1PH = 5).
TOTAL INCOME = the result of adding 'income_value' based on 'income_user'.

for query problems I don't understand what to do. my mind is still blank.
my query is still like this:
 SELECT * FROM incomes
Reply


Messages In This Thread
RE: display data from the database - by php_rocs - 04-21-2019, 11:01 AM
RE: display data from the database - by DELE - 04-21-2019, 08:15 PM
RE: display data from the database (summarizes data) - by DELE - 04-22-2019, 04:37 AM



Theme © iAndrew 2016 - Forum software by © MyBB