MYSQL INT addition

Question

I'm trying to bring the INT values from mysql and do a addition and finally update the database. But this doesn't seem to do update? How can I fix this?

$resultSecond = mysql_query("SELECT * FROM Furniture");
while($lineSecond = mysql_fetch_array($resultSecond)) {
    $item     = $lineSecond["Item"]; 
    $janD     = $lineSecond["January"];
    $febD     = $lineSecond["February"];
    $marD     = $lineSecond["March"];
    $pastVals = $lineSecond["yearSale"];
    $totalCT  = $lineSecond["monthSale"];

    $totThisM = ($janD + $febD + $marD + $pastVals + $totalCT);
    mysql_query("UPDATE Furniture SET Furniture = '".$totThisM."' WHERE Item ='$item' LIMIT 1");
}

use mysql_error() and see whats going on for the update command. — Abhik Chakraborty
– Abhik Chakraborty, Commented Feb 12, 2014 at 9:46
We don't know, because you don't show either the database schema or the error message you get. But we do know that this is a bad way to update; you can update all your database with a single UPDATE query, as in UPDATE Furniture SET Furniture = January + February + .... — Jon
– Jon, Commented Feb 12, 2014 at 9:46

ʰᵈˑ · Accepted Answer · 2014-02-12 10:05:54Z

2

Why not just use MySQL?

UPDATE `Furniture`
SET `Furniture` = (`January`+`February`+`March`+`yearSale`+`monthSale`)

Test data

+---------+---------+-------+
| number1 | number2 | total |
+---------+---------+-------+
|       1 |       5 |     0 |
|       2 |       3 |     0 |
+---------+---------+-------+

And I run my query;

UPDATE table SET total = (`number1`+`number2`);

And the table is updated;

+---------+---------+-------+
| number1 | number2 | total |
+---------+---------+-------+
|       1 |       5 |     6 |
|       2 |       3 |     5 |
+---------+---------+-------+

Notes

Removed WHERE clause after comment from CodeBird.
Adjusted query after comments from Ravinder

edited Feb 12, 2014 at 10:05

answered Feb 12, 2014 at 9:52

ʰᵈˑ

11.4k3 gold badges31 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

CodeBird Over a year ago

yep, you don't even need the WHERE Item=$item neither the while loop

Ravinder Reddy Over a year ago

You also don't need item field value for summing up.

Ravinder Reddy Over a year ago

It should be just SET Furniture = ( January + February + March + yearSale + monthSale )

NathaliaZeed Over a year ago

Thanks h | CodeBird | Ravinder.

ncrocfer · Accepted Answer · 2014-02-12 09:58:47Z

0

Try this :

mysql_query("UPDATE Furniture SET Furniture = '". $totThisM ."' WHERE Item ='". $item ."' LIMIT 1");

Edit

Not the right answer, see comments for details.

edited Feb 12, 2014 at 9:58

answered Feb 12, 2014 at 9:47

ncrocfer

2,5504 gold badges33 silver badges39 bronze badges

3 Comments

CodeBird Over a year ago

won't change anything

ncrocfer Over a year ago

I think the variable is not converted into its value. In PHP you can pass variable into double quotes (like $return = "The value is $var";) but not $return = 'The value is $var'; // Error).

CodeBird Over a year ago

it is in double quotes, the whole query is in double quotes. That's not his issue. He has " then ' so the var will work normally there.

Collectives™ on Stack Overflow

MYSQL INT addition

2 Answers 2

Test data

Notes

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Test data

Notes

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related