|
|
Business › Re: Paddy Adenuga: 10 Things You Didn't Know About Mike Adenuga’s Son by LegendsCoded(m): 1:33am On Feb 01, 2018 |
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. |
Business › Re: Paddy Adenuga: 10 Things You Didn't Know About Mike Adenuga’s Son by LegendsCoded(m): 10:23pm On Jan 31, 2018 |
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 |
Business › Re: Why Paddy Adenuga's Bid To Acquire Chevron Failed by LegendsCoded(m): 9:52pm On Jan 31, 2018 |
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. � � � |
Business › Re: Inside Olu Okeowo's Lagos Mansion "Palacio De Okeowo" (photo, Video) by LegendsCoded(m): 6:14pm On Jan 31, 2018 |
FTC...!!!  No comment yet. |
|
|
|
|
|
Programming › Linux Experts Get In by LegendsCoded(op): 12:40pm On Jan 31, 2018*. Modified: 2:07am On Oct 08, 2019 |
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.. |
Business › Re: Why Paddy Adenuga's Bid To Acquire Chevron Failed by LegendsCoded(m): 12:13pm On Jan 31, 2018 |
This guy is just trying to be relevant.
Next...... � |
Education › Re: Osula Daniel Enahoro Expelled From DELSU For Refusing To 'Bribe' For His Project by LegendsCoded(m): 11:31pm On Jan 30, 2018 |
Who else couldn't read the whole epistle?? |
Crime › Re: 'Touch Me Not Campaign': Girls Sexually Assaulted Make Shocking Revelations by LegendsCoded(m): 11:26pm On Jan 30, 2018 |
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 |
Celebrities › Re: April Joju Muse: "I Had My First Lesbian Experience At 6 In Church" by LegendsCoded(m): 11:20pm On Jan 30, 2018 |
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.. |
European Football (EPL, UEFA, La Liga) › Re: Swansea Vs Arsenal (3 - 1) On 30th January 2018 by LegendsCoded(m): 10:49pm On Jan 30, 2018 |
Enemyofpeace: E don happen. Arsenal missing Sanchez 
the reason he was solded by United Wow solded for real  |
European Football (EPL, UEFA, La Liga) › Re: Swansea Vs Arsenal (3 - 1) On 30th January 2018 by LegendsCoded(m): 10:45pm On Jan 30, 2018 |
|
Career › Re: How Are Death Benefits Paid In Nigeria? by LegendsCoded(m): 7:48pm On Jan 29, 2018 |
. |
TV/Movies › Re: Bbnaija Housemate Khloe Twerks For Rico (VIDEO) by LegendsCoded(m): 3:21pm On Jan 29, 2018 |
Following |
Celebrities › Re: Davido And Girlfriend, Chioma Avril Rowland Loved Up In New Photo by LegendsCoded(m): 11:36am On Jan 26, 2018 |
sollybaby: But i fine pass chioma na.. Rich boo should come ooo Abi  |
Sports › Re: James McCarthy Suffers Double Leg Break by LegendsCoded(m): 8:53pm On Jan 20, 2018 |
Ewoo |
Programming › Re: Please Help Look At My Code (what is wrong with my code ) by LegendsCoded(m): 7:34pm On Jan 19, 2018 |
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 |
Webmasters › I Need Someone To Pay For Fb Ads by LegendsCoded(op): 10:12am On Jan 17, 2018*. Modified: 2:07am On Oct 08, 2019 |
Good day fellas...
Do you run fb ads?
Hit me up for a serious biz it's urgent..
Whatsapp only |
Crime › Re: Boyfriend's Lips Bitten Off While Defending His Girlfriend Against Abuser (Photo by LegendsCoded(m): 7:49pm On Jan 16, 2018 |
|
Crime › Re: Boyfriend's Lips Bitten Off While Defending His Girlfriend Against Abuser (Photo by LegendsCoded(m): 7:48pm On Jan 16, 2018 |
Gbege |
Programming › Re: Help With Htacess Multiple Rewrite Rules by LegendsCoded(m): 12:14am On Jan 15, 2018 |
youngscholar: The first one working...The second is not. I'll give u a code tomorrow |
Programming › Re: Please Help Look At My Code (what is wrong with my code ) by LegendsCoded(m): 12:13am On Jan 15, 2018 |
nicolas247: it is not giving error but just that it is returning wrong value Have you fixed it? |
Webmasters › Re: Half-goodbye: Windows 8.1 Officially Enters Extended Support by LegendsCoded(m): 11:49am On Jan 11, 2018 |
hostkobo: Go Linux, Be Free.
regards HK Bro u dy there.. Rocking my Parrot... |
Programming › Re: 20k For Grabs by LegendsCoded(m): 3:01am On Jan 11, 2018 |
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. |
Programming › Re: Help With Htacess Multiple Rewrite Rules by LegendsCoded(m): 2:38am On Jan 11, 2018 |
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] |
Programming › Re: Please Help Look At My Code (what is wrong with my code ) by LegendsCoded(m): 2:29am On Jan 11, 2018 |
Whats the response/error u get? |