₦airaland Forum

nicolas247:
yes i am

nicolas247:
Please what is wrong with my code

<?php
include('connect.php');
if (isset($_GET["d1"])) { $d1 = $_GET["d1"]; } else { $d1=0; };
if (isset($_GET["d2"])) { $d2 = $_GET["d2"]; } else { $d2=0; };
$result = $db->prepare("SELECT *, SUM(loan_amt), SUM(loan_int), SUM(saving), SUM(total_ded) FROM transaction WHERE trans_date BETWEEN :a AND :b GROUP BY memberId ";
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
<tr class="record">
<td><?php echo $row['memberId']; ?></td>
<td><?php echo $row['trans_date']; ?></td>
<td><?php echo $row['fname']; ?></td>
<td><?php echo $row['SUM(loan_amt)']; ?></td>
<td><?php echo $row['SUM(loan_int)']; ?></td>
<td><?php echo $row['SUM(saving)']; ?></td>
<td><?php echo $row['SUM(total_ded)']; ?></td>

</tr>
<?php
}
?>

What i want to archive is to be able to sum same memberId within a date range please what am i doing wrong
thanks for the help

4kings:
Just seeing this.
Would do that soon...

4kings:
Just seeing this.
Would do that soon...

4kings:
What about the sections?
Not including it anymore.

I clicked on a notification and it showed file not found. Guess development is still in progress.

It's great.
But i want the sections back though, i wasn't able to open them using laptop throughout last year hope there would be active when your app is done.

Nice Work.

4kings:
Something's wrong.
chat me up and see if it goes through.

4kings:
Nope, still taking back to the login page after clicking post or hitting enter.

Did you see the message i sent you?

4kings:
Ya. Wanted to make an extra comment on your post and the next post by "bc", but couldn't.

4kings:
Ya. Wanted to make an extra comment on your post and the next post by "bc", but couldn't.

4kings:
I've not been able to make a post for 3 days now.
Whenever i try it gets me back to login page.
Though i made two posts about 3 or 4 days ago, but not ever since.

Tried with mobile version also, but to no avail.

4kings:
What about the sections?
Not including it anymore.

I clicked on a notification and it showed file not found. Guess development is still in progress.

It's great.
But i want the sections back though, i wasn't able to open them using laptop throughout last year hope there would be active when your app is done.

Nice Work.

4kings:
What about the sections?
Not including it anymore.

I clicked on a notification and it showed file not found. Guess development is still in progress.

It's great.
But i want the sections back though, i wasn't able to open them using laptop throughout last year hope there would be active when your app is done.

Nice Work.

terry50:
I think it's your web certificate is the problem it seems chrome doesn't recognize it as a valid certificate that is a fact from me.

Otisjay10:
Which programming language did u use to build it frm scratch

ndiuel:
Kudos to u @op for ur efforts.Though I must say it looks a little too much like facebook

4kings:
Hmmm, I hate working on web applications...currently working on one though, but that's because i have to, for an interface of a prototype i need to submit.

Holla me when you need help on data mining, would love to be interested then.

PM me for my contact though, or chat me up on friendzone, can't drop my number here.

Jenifa123:
It's increasing and we are looking at building a team...
Interested individuals can indicate and drop their whatsapp number

terry50:
Well I give a good heads up on the site, but looks like Facebook's lite theme though, you need to be careful as you may be inflicting copyright infringement, I would recommend you to change your theme to something else well I would love to know what software you used to design the site or did you build it from scratch via hard coding, also more efforts to you sir, keep up the good work.

klosety45:
See this one go create forum when go soon die a natural death. Just blc nairaland is popular and blazing u think this 10 years ago when the blogosphere was'nt crowded. Well, u had better convert that forum to a blog now and slam adsense on it before u go broke like most naija citizen, am telling u from experience and most persons i would'nt want to mention their names. Listen again, go and convert that forum to a niche blog and hire writers and apply for adsense or think of a good monetization and be happy. Unless you dont have the intention of making money from that forum then that would be fine, if u do then get ready for hunger 101 because u go hear wiiiiii.....
Lol Modified--- are u also the owner of this one earlyguru.com laughing in swahilli now. Hugerbad go soon be ur username soon... Infact just da head to the headies of fia...

wane01:
yea it works now ....
I tried it before using tor browser on Linux buh I tried with chrome on my phone and it went .... nice idea tho ....
am always glad to see female programmers

4kings:
I had issues...
I posted something concerning the therapy on the homepage 2 days ago and it did not appear, only my first comment "hmm" appeared.
I also sent you a pm with the copy of the message and later the message just magically disappeared, when i clicked your profile.
Help out....
Thanks.

blessedemperor:
thank sir, please if i save as image will i be able to call it for verification?

wane01:
yea it works now ....
I tried it before using tor browser on Linux buh I tried with chrome on my phone and it went .... nice idea tho ....
am always glad to see female programmers