display data from the database (summarizes data) |
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 |
Messages In This Thread |
display data from the database (summarizes data) - by DELE - 04-21-2019, 09:55 AM
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 php_rocs - 04-22-2019, 01:24 AM
RE: display data from the database (summarizes data) - by DELE - 04-22-2019, 04:37 AM
RE: display data from the database (summarizes data) - by InsiteFX - 04-22-2019, 08:23 AM
RE: display data from the database (summarizes data) - by DELE - 04-22-2019, 09:51 AM
RE: display data from the database (summarizes data) - by Wouter60 - 04-22-2019, 11:03 AM
RE: display data from the database (summarizes data) - by DELE - 04-22-2019, 05:42 PM
RE: display data from the database (summarizes data) - by php_rocs - 04-24-2019, 01:20 PM
RE: display data from the database (summarizes data) - by DELE - 04-25-2019, 09:20 AM
|