₦airaland Forum

Hi NL Programmers, pls this php code is running me mad. I really need your help.

In my database Table, I have 2 rows. The first is named 'User' and d second is named 'amount'.

There are two records in the table:

Record 1: User=dami24, Amount=120

Record 2: User=dami24, Amount=30

What im trying to do is to "Select Amount From Table Where user=dami24"

After selecting the amounts, i want to add them together, so the final result should be 150 (120+30).

l've tried all i could without the desired result. Array_sum, implode/explode, mysql-fetch_array, yet no result

pls help me out

lillylove2:
Hi NL Programmers, pls this php code is running me mad. I really need your help.

In my database Table, I have 2 rows. The first is named 'User' and d second is named 'amount'.

There are two records in the table:

Record 1: User=dami24, Amount=120

Record 2: User=dami24, Amount=30

What im trying to do is to "Select Amount From Table Where user=dami24"

After selecting the amounts, i want to add them together, so the final result should be 150 (120+30).

l've tried all i could without the desired result. Array_sum, implode/explode, mysql-fetch_array, yet no result

pls help me out

Try this
<?php



$query = "SELECT * FROM `table` WHERE `User`='dami24'";
$result = mysqli_query ($link, $query) ;
$row = mysqli_fetch_assoc($result) ;
$row_cnt = $result->num_rows;
$sum = 0;
$cnt = 0; //try 1 if 0 doesnt work properly
while ($cnt < $row_cnt)
{
$row = mysqli_fetch_assoc($result) ;
$amount = $row['amount'] ;
$sum = $sum + $amount;
$cnt++;
}
? >

yorex2011:
Try this <?php


$query = "SELECT * FROM `table` WHERE `User`='dami24'"; $result = mysqli_query ($link, $query) ; $row = msqli_fetch_assoc($result) ; $row_cnt = $result->num_rows; $sum = 0; $cnt = 0; //try 1 if 0 doesnt work properly while ($cnt < $row_cnt) { $row = msqli_fetch_assoc($result) ; $amount = $row['amount'] ; $sum = $sum + $amount; $cnt++; } ? >

It's showing error: Unexpexted T Variable on this line:
$row_cnt = $result->num_rows;
... and the ending curl bracket ( } ).
And please how do i echo the result out, and also store it into a vairable
Thanks

lillylove2:
It's showing error: Unexpexted T Variable on this line:

$row_cnt = $result->num_rows;

... and the ending curl bracket ( } ).

And please how do i echo the result out, and also store it into a vairable

Thanks

Ensure your semicolons are correct... Send a screen shot of the code if possible

And mysqli is properly spelt

yorex2011:
Ensure your semicolons are correct... Send a screen shot of the code if possible

And mysqli is properly spelt

Ive cross checked it. It's properly spelled. And no ommission. Pls help me out

Pls help me out o

lillylove2:
Pls help me out o

Start by showing us the codes you written that is not working.

I cant believe all the programmers here are only programmers by mouth. It is well o

lillylove2:
I cant believe all the programmers here are only programmers by mouth. It is well o

Please Show the code you tried.

lillylove2:
I cant believe all the programmers here are only programmers by mouth. It is well o

Be mindful of how you seek assistance....

lillylove2:
I cant believe all the programmers here are only programmers by mouth. It is well o

Only in nairaland programming section people will seek coding help without posting codes or screenshot of codes.

Well not surprised, dhtml don kuku talk am before.

lol.. you can sum it up right from your SQL statement

SELECT SUM(column_name) FROM table_name WHERE condition;

Select sum(Amount) From Table Where user=dami24;

coldspot:
lol.. you can sum it up right from your SQL statement

SELECT SUM(column_name) FROM table_name WHERE condition;

Select sum(Amount) From Table Where user=dami24;

Thanks. How do i echo the result?

maekhel:
Only in nairaland programming section people will seek coding help without posting codes or screenshot of codes.

Well not surprised, dhtml don kuku talk am before.

Easier to just call yourself lillylove(f) and flutter your eyelashes.

lillylove2:
Thanks. How do i echo the result?

select sum(amount) as total from table where user = dami24

echo $row['total'];

show your own code

lillylove2:
Thanks. How do i echo the result?

$sql = mysqli_query("SELECT SUM(Amount) as total FROM table where user='dami24'" or die(mysqli_error());

$rs = mysqli_fetch_assoc($sql);
$sum = $rs['total'];

echo $sum;

Thanks everybody for taking your time out to help me. Its finally working.

hollyfat:
$sql = mysqli_query("SELECT SUM(Amount) as total FROM table where user='dami24'" or die(mysqli_error());

$rs = mysqli_fetch_assoc($sql);
$sum = $rs['total'];

echo $sum;

Does this also work on regular mysql (not mysqli) ?
I tried it, it didnt work

lillylove2:
Does this also work on regular mysql (not mysqli) ? I tried it, it didnt work

. You can use mysql if mysqli didn't work.

My God! Its multiplication im looking for not addition. Im totally unserious! Please help me out

lillylove2:
My God! Its multiplication im looking for not addition. Im totally unserious! Please help me out

$sql = mysql_query("select amount from table where user='dami24'" or die(mysql_error());
$product = 1; //initialize your product
while($rs = mysql_fetch_assoc($sql)){
$amt = $rs['amount']; //get the amount
$product *= $amt;
}
echo $product;

hollyfat:
$sql = mysql_query("select amount from table where user='dami24'" or die(mysql_error());
$product = 1; //initialize your product
while($rs = mysql_fetch_assoc($sql)){
$amt = $rs['amount']; //get the amount
$product *= $amt;
}
echo $product;

My God It Worked! Im really, really grateful. I can't thank you enough.

I spent up to 3 hours before i was finally able to make the other one work, only to realize it was multiplication i was seeking, not addition.

I had even given up, and accepted my fate that i will never be a programmer, only for me to try out ur code and it worked!

Thanks very much.

lillylove2:
My God It Worked! Im really, really grateful. I can't thank you enough.

I spent up to 3 hours before i was finally able to make the other one work, only to realize it was multiplication i was seeking, not addition.

I had even given up, and accepted my fate that i will never be a programmer, only for me to try out ur code and it worked!

Thanks very much.

You are welcome

lillylove2:
Hi NL Programmers, pls this php code is running me mad. I really need your help.

In my database Table, I have 2 rows. The first is named 'User' and d second is named 'amount'.

There are two records in the table:

Record 1: User=dami24, Amount=120

Record 2: User=dami24, Amount=30

What im trying to do is to "Select Amount From Table Where user=dami24"

After selecting the amounts, i want to add them together, so the final result should be 150 (120+30).

l've tried all i could without the desired result. Array_sum, implode/explode, mysql-fetch_array, yet no result

pls help me out

This is how to make array_sum work.

Set a variable holding an empty array:

$loop_results = array();

Query your db:

$sql = ("SELECT `amount` FROM `table` WHERE `user`='".dami24."'" ) ;

$query = mysqli_query($con, $sql);

If(mysqli_num_rows($query) > 0{
while($rows = mysqli_fetch_assoc($query){
$loop_results[] = $rows['amount'];
}
}

If(empty($loop_results) == false){

$amount_sum = array_sum($loop_results);

echo $amount_sum;
}

lillylove2:
My God! Its multiplication im looking for not addition. Im totally unserious! Please help me out

In that case replace array_sum with array_product.