nicolas247:
people just they look dey pass?

tollyboy5:

Lolz you think sey e easy. I no b guru but you 4 make easier by telling which language you use

LegendsCoded:
Whats the response/error u get?

Softhands:
Delete line by line and keep testing each line to know where the problem is... Or check stack overflow..

nicolas247:

i have checked stack overflow i dont have reference i can relate with. i don tire

tollyboy5:

Lolz you think sey e easy. I no b guru but you 4 make easier by telling which language you use

bet9ja:



Seriously, are you a programmer at all? Someone posted a source code and you can't even tell if it is a PHP code or whatever. That is really bad.

bet9ja:



Seriously, are you a programmer at all? Someone posted a source code and you can't even tell if it is a PHP code or whatever. That is really bad.

tollyboy5:

I'm nt guru na. I'm still learning but based on embedded design for microcontrollers. Na assembly c/c++ b my major

nicolas247:


it is not giving error but just that it is returning wrong value

LegendsCoded:


Have you fixed it?

yorex2011:
You have tables for January , February... Etc ??

Why not create one table and have a month column, then create you sql to search through the months you need.

What exactly are you trying to achieve, cos i don't seem to understand..

Who taught you php?

Singlecliq:
let me see the result you are getting.
You should be getting this with the code I am seeing

StaffID loan_amt Saving_ded total_ded
122 20 30 50
122 20 30 50
122 20 30 50
235 60 40 100
235 60 40 100
235 60 40 100

Yes but the result i want is this
staff id loan_amt Saving_ded total_ded
112 60 90 150
235 180 120 300

Singlecliq:



<?php

require 'config.php';

$january=mysqli_query($con,'SELECT staffid, saving_ded, total_ded
FROM january
UNION ALL
SELECT staffid, saving_ded, total_ded
FROM february
UNION ALL
SELECT staffid, saving_ded, total_ded
FROM march
');

//setting up as an array
$month = array();

//looping through and saving as an array
while ($row = mysql_fetch_assoc($january)) $month[] = $row;

//setup a new array after loop

$result = array();

foreach ($month as $val) {

if (!isset($result[$val['staffid']]))

$result[$val['staffid']] = $val;

else

$result[$val['staffid']]['saving_ded'] += $val['saving_ded'];
}

$result = array_values($result);

// reindex array

nicolas247:
Thanks but i still got this error

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

Warning: A non-numeric value encountered in D:\xampp\htdocs\2017\test.php on line 12

benjibabs:
Have you resolved it?

You should also provide details of what your code should achieve and not the output only.

From the code you posted, I think the result you are expecting is the sum of saving_ded, total_ded from Jan, feb & mar tables for each staffid. Is this accurate? If it is, your code is not complete yet. What your code is returning as it is is a 2 level array with all rows from each table as arrays. You need to find a way to select each staffid and corresponding xyz_ded values and add up the values, save them in another array and them echo them as needed. You may also be able to use MySQL statements to sum up the values before retrieving with php. I’ll try my hands on it later today and post my codes.

Happy coding !

benjibabs:
Here you go:

Note:
I used PDO instead of mysqli to connect to mysql database. However, the logic will still work so far you have the data in a multilevel array after using mysqli.

// Pull all the required data from the three tables into one 2 level array
$sql = 'select * from january UNION ALL select * from february UNION ALL select * from march';
$query = $pdo->prepare($sql);
$query->execute();
$row = $query->fetchAll();

// Pull a list of all the staffid from one of the table assuming we have the same number of IDs in all tables
$sql1 = 'select staffid FROM january';
$query = $pdo->prepare($sql1);
$query->execute();
$staffIdList = $query->fetchAll();

// start a loop to loop through the list of the staffids
foreach ($staffIdList as $staffIdList) {

//initialize the variable that will store the sum of each column
$loanamt = 0;
$saving = 0;
$total = 0;

//start a loop to loop through the 2 level array
foreach ($row as $key => $value){

// use an IF statement to select each of the staffids and corresponding columns (loan_amt etc) and add them together as the loop runs
if ($row[$key]['staffid']== $staffIdList['staffid']){
$loanamt += $row[$key]['loan_amt'];
$saving += $row[$key]['Saving_ded'];
$total += $row[$key]['total_ded'];
}
}
// print out the values after each staffid iteration
echo $staffIdList['staffid']." ".$loanamt." ".$saving." ".$total."</br>";
}



Depending on the number of columns and tables you are dealing with, the solution might not be efficient.

Happy coding!

benjibabs:
Here you go:

Note:
I used PDO instead of mysqli to connect to mysql database. However, the logic will still work so far you have the data in a multilevel array after using mysqli.

// Pull all the required data from the three tables into one 2 level array
$sql = 'select * from january UNION ALL select * from february UNION ALL select * from march';
$query = $pdo->prepare($sql);
$query->execute();
$row = $query->fetchAll();

// Pull a list of all the staffid from one of the table assuming we have the same number of IDs in all tables
$sql1 = 'select staffid FROM january';
$query = $pdo->prepare($sql1);
$query->execute();
$staffIdList = $query->fetchAll();

// start a loop to loop through the list of the staffids
foreach ($staffIdList as $staffIdList) {

//initialize the variable that will store the sum of each column
$loanamt = 0;
$saving = 0;
$total = 0;

//start a loop to loop through the 2 level array
foreach ($row as $key => $value){

// use an IF statement to select each of the staffids and corresponding columns (loan_amt etc) and add them together as the loop runs
if ($row[$key]['staffid']== $staffIdList['staffid']){
$loanamt += $row[$key]['loan_amt'];
$saving += $row[$key]['Saving_ded'];
$total += $row[$key]['total_ded'];
}
}
// print out the values after each staffid iteration
echo $staffIdList['staffid']." ".$loanamt." ".$saving." ".$total."</br>";
}



Depending on the number of columns and tables you are dealing with, the solution might not be efficient.

Happy coding!

nicolas247:
You are the bomb
thanks so much
problem solved though i am finding it difficult to add a column with staff's name.

benjibabs:


You are welcome! I'm glad that got you off the hook.

You can easily add the column for the staff name by pulling the column with the names along with the staffid as below:

. . .

// Pull a list of all the staffid & Staff_name from one of the table assuming we have the same number of IDs in all tables
$sql1 = 'select staffid, staff_name FROM january';
$query = $pdo->prepare($sql1);
$query->execute();
$staffIdList = $query->fetchAll();

and then echo it out as below with the other columns:
. . .

// print out the values after each staffid and staff_name iteration
echo $staffIdList['staffid']." ".$staffIdList['staff_name']." ".$loanamt." ".$saving." ".$total."</br>";

change staff_name to the name of the column where you have the staff names.

Happy coding!