₦airaland Forum

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

People just they pass nii
help a brother o

thanks

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

Are u selecting from a table or wah?

yes am selecting from a table call TRANSACTION

Jenifa123:
Are u selecting from a table or wah?

yes i am

nicolas247:
yes i am

U should look at ur query again?

You're not stating a problem. Did you try executing the SQL directly in your database engine ? if so, did it work ? If yes, then we can safely assume the problem is from the PHP end of your code. Otherwise, take a second look at your SQL query.

Is your PHP code not producing the desired result ? Or maybe you're not getting any output. Points like this helps narrow down the problem.

Please try and be more specific about what you want.