KazeFlame
10-26-2012, 02:47 PM
Hello guys! Please teach me how to add an integer to a column.
Here is my code but it doesn't work.
$sql = "UPDATE `flashgames`.`flashgames` SET `views` = '+1' WHERE `flashgames`.`gameid` = 1;";
Fou-Lu
10-26-2012, 02:50 PM
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
11-05-2012, 06:11 AM
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
11-05-2012, 04:56 PM
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).