Android Question Php question for b4a

[tufanv]

Hello

I use a php on server side to retrieve to my b4a app. I have in my php code following :

                        $q = "SELECT * FROM tahmincilerintahminleri where username= '".$user."' and Tuttu='2'  ";
                        $r = mysql_query($q);
                        $a = mysql_fetch_assoc($r);
                        $tutmayankar='0';
                        while(($row = mysql_fetch_assoc($r))) {
                             $tutmayankar =  $tutmayankar + $a['guven'];

Here I want to get the sum of the column "guven" for each row with $tutmayankar.. I use while as above. But there is a problem with this. I get the wrong result. I think i am making a mistake in the code. ( I tested it , I add a new row to my sql database with guven column =4 and as a result $tutmayankar increases for 3 for example.

Can you see any problem with the code ?

TY

 

[DonManfred]

you are dfining a string

$tutmayankar=0;
                        while(($row = mysql_fetch_assoc($r))) {
                             $tutmayankar += $row['guven'];

 

[tufanv]

Yes ! Thanks very Much. That's fixed it !

 

[LucaMs]

You can use a simple function, instead of that loop:

http://www.w3schools.com/sql/sql_func_sum.asp

(you can add a Where clause, which is missing in that page, of course)

 

[DonManfred]

you can add a Where clause, which is missing in that page, of course

No, it is NOT missing

$q = "SELECT * FROM tahmincilerintahminleri where username= '".$user."' and Tuttu='2' ";

 

[LucaMs]

No, it is NOT missing

I meant it is missing in the page at link I posted