Adding integers from a variable to mysql column

Question

i'm wondering how can i add an integer which i have assigned in a variable to a mysql table's column using INSERT.

this is my code:

//Connect to database
include ("connnect.php");

$countv = "10"
$insert  = ("INSERT INTO table1 (id,count) VALUES ('$id',+$countv)";
mysql_query($insert) or die(mysql_error());

the count column is set to int and the default value is '0' Normally i add 10 using +10 , but now i want to try adding it via a variable. so i set "count" column to add $countv's value interger.

this script can add 10 to the column count, but when i try it the second time(which is using UPDATE table1 SET count = +$countv WHERE id='123') , it still remains as 10. is there any mistakes i'm making or is there a better way to do this?

Update script

  mysql_query("UPDATE table1 SET count = + $countv WHERE id='123'")
            or die(mysql_error());

Thanks and have a nice day.

(SOLVED : i forgotten to add count infront of + $countv in the update script. thanks for those who help)

What are you incrementing? Since you are adding a new row (which by default will have a count of 0) it seems logical that the result will be 10 each time. If you do an update, it should be better. — Bas Slagter
– Bas Slagter, Commented Oct 4, 2011 at 8:59

bumperbox · Accepted Answer · 2011-10-04 09:00:10Z

9

try this syntax

update table1 set count = count + $countv where id = '123'

answered Oct 4, 2011 at 9:00

bumperbox

10.2k6 gold badges46 silver badges66 bronze badges

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

Comments

mrRuben · Accepted Answer · 2011-10-04 08:59:18Z

0

you can do this in two ways: - first retrieve the value, update it with php and write it back to the mysql table - or a simple sql query: UPDATE leaderb SET count = count + 10 WHERE ....

since you are inserting in mysql you don't have an initial value there. so you should use update to change an existing row/record.

answered Oct 4, 2011 at 8:59

mrRuben

16 bronze badges

1 Comment

ETAN Over a year ago

Normally i add 10 using +10 like you said , but now i want to try adding it via a variable. so i set "count" column to add $countv's value interger.

konsolenfreddy · Accepted Answer · 2011-10-04 09:00:34Z

0

Your update query should be:

$query ="UPDATE table1 `count` = `count` + $countv WHERE id=123";

Mind you, count is a reserved word in MySQL so it should be in backticks

answered Oct 4, 2011 at 9:00

konsolenfreddy

9,7091 gold badge28 silver badges36 bronze badges

Comments

galtzhayek · Accepted Answer · 2011-10-04 09:03:07Z

0

i have no idea how it worked for you since u add the names '$id' and '$countv' instead of thier values.

i think you should swap that:

$insert  = "INSERT INTO table1 (id,count) VALUES ('$id',+$countv)";

with:

$insert  = "INSERT INTO table1 (id,count) VALUES ('$id', +" . $countv . ")";

if id is also a php int (i assume so) u need:

$insert  = "INSERT INTO table1 (id,count) VALUES ('" . $id . "', +" . $countv . ")";

tell me how it went :)

answered Oct 4, 2011 at 9:03

galtzhayek

759 bronze badges

Comments

RonnyKnoxville · Accepted Answer · 2011-10-04 09:04:35Z

0

Its because you are replacing the value each time with 10. The program does not know the number that is in the database.

You need to retrieve the data first, update the value and then place it back in the database

answered Oct 4, 2011 at 9:04

RonnyKnoxville

6,43410 gold badges50 silver badges80 bronze badges

Comments

hichris123 · Accepted Answer · 2014-01-30 02:29:11Z

0

Try this:

UPDATE table1 SET count = count+$countv WHERE id = '123'

edited Jan 30, 2014 at 2:29

hichris123

10.3k15 gold badges58 silver badges70 bronze badges

answered Oct 4, 2011 at 9:00

Kasper Munck

4,1912 gold badges29 silver badges50 bronze badges

Collectives™ on Stack Overflow

Adding integers from a variable to mysql column

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related