₦airaland Forum

pol23:
#Adenuga and #bbn...
I understand nobody celebrate failure...
Some people were born great,it's nothing close to big deal everything He has done...
It's just a normal thing we've all done...
Paddy's Babaolowo agreed,he hasn't take risk like many of us...but that doesn't count if you're not on top there..
I use to buy portable electronics with my school fee to make little profit,I thought I was hustling until I saw someone sponsoring his education and sending his family something too.....Dude's doing good now..but nothing close to Paddy...
Life's not just fair...I thank God for my life.
I celebrate paddy.
I celebrate every hustler out there.
I celebrate myself.

You just summarized the whole thing.

NextGovernor:
So becos of Paddy I shouldn't rest for the day abi. Paddy this Paddy that.

I go leave nairaland for u and paddy

You just said my mind

opad:
Relevant, really? For his entrepreneural pursuit? Did he log in to post the memoir on Nairaland?
Wait sef, if he could have the means to purchase Chevron, how much could "relevance" be worth?

Bruh we ain't fighting..

I guess you don't follow him up on IG or Twitter.

He is trying to be relevant period.
� � �

FTC...!!!

No comment yet.

Hi everyone.

If you're interested in using a linux distro and you are based in Port Harcourt, good news.

I have variety of linux diatros doe giveaway (free installation)

Soft and hard copy available.

Available diatros are

*Ubuntu
*Debian
*Kali Linux (latest)
*Parrot Sec OS (latest) downloaded 1st Jan.
Etc


Contact
For free installation and soft copy too.

Paid pentest tools available too

PORT HARCOURT ONLY FOR NOW..

This guy is just trying to be relevant.

Next...... �

Who else couldn't read the whole epistle??

jerrybakermillz:
Hmmm.....this is why FG should includ sexdoll into this year budget ,so that all these low self esteem men can have something to fuccccck when conji hold them

Laff dn tear my pant

EternalTruth:
mumu. Why you dey always quote the post before you comment.
You have been on nairaland for more than 10 years but you still never get sense

Bros why na...
You just committed murder..

Enemyofpeace:
E don happen. Arsenal missing Sanchez



the reason he was solded by United

Wow solded for real

LesbianBoy:
What! jesu! With this english you will end up in mc donalds

Savagery..

.

Following

sollybaby:
But i fine pass chioma na.. Rich boo should come ooo

Abi

Ewoo

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!

Best answer ever

Good day fellas...

Do you run fb ads?

Hit me up for a serious biz it's urgent..

Whatsapp only

donstan18:
hb

Did u mean hb pencil ✏??

Gbege

youngscholar:
The first one working...The second is not.

I'll give u a code tomorrow

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

Have you fixed it?

hostkobo:
Go Linux, Be Free.

regards
HK

Bro u dy there..

Rocking my Parrot...

occi077:
I need someone to teach me how to make website with user login system. I am willing to pay 20k.


Contact me

09039319102

Keep your money..

And I'll teach u for free.

youngscholar:
RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([^/]*)$ /topics.php?url=$1 [L]

RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([^/]*)$ /marktet.php?url=$1 [L]

How can I make both working..Only the first one works..Please assist.

Try this RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([^/]*)$ /topics.php?url=$1 [L]
RewriteRule ^([^/]*)$ /marktet.php?url=$1 [L]

Whats the response/error u get?