How to add integer to a column?

[KazeFlame]

Hello guys! Please teach me how to add an integer to a column.

Here is my code but it doesn't work.

PHP Code:

$sql = "UPDATE `flashgames`.`flashgames` SET `views` = '+1' WHERE `flashgames`.`gameid` = 1;"; 


[Fou-Lu]

This is a SQL issue, not a PHP one.
You cannot increment in SQL, you must set the value to its increment. That would be a simple SET `views` = `views` + 1.

[paulinetaylor85]

You will insert a new table via using SQL code add your column follow it. I have given the example. Insert into Stu_Table values(1,'name');

[Fou-Lu]

Originally Posted by paulinetaylor85

You will insert a new table via using SQL code add your column follow it. I have given the example. Insert into Stu_Table values(1,'name');

Um, what? Are you referring to the use of an auto increment pk? That will have no practical purpose on this issue; the OP is incrementing a different field in the db, not the primary key (which cannot be incremented as shown in the op as that would eventually cause conflict on other pk).