php mysql 整行值_php – 在MySQL中将行值增加和减少1

不需要增加/减少字段值的两个查询：

mysql_query(“UPDATE table SET field = field 1 WHERE id = $ number”);

是一个完全有效的查询，你可以看到下一个：

mysql> describe points;

+--------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+--------+---------+------+-----+---------+-------+

| uid | int(11) | NO | PRI | NULL | |

| points | int(11) | YES | | 0 | |

+--------+---------+------+-----+---------+-------+

2 rows in set (0.05 sec)

mysql> insert into points VALUES (1,0),(2,0);

Query OK, 2 rows affected (0.14 sec)

mysql> select * from points;

+-----+--------+

| uid | points |

+-----+--------+

| 1 | 0 |

| 2 | 0 |

+-----+--------+

2 rows in set (0.05 sec)

mysql> update points set points = points+1 where uid = 1;

Query OK, 1 row affected (0.27 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from points;

+-----+--------+

| uid | points |

+-----+--------+

| 1 | 1 |

| 2 | 0 |

+-----+--------+

2 rows in set (0.00 sec)

经过测试，你确定你进入你的if(loggedin())子句吗？

我必须同意KM，会很高兴看到echo $ query1的输出;或echo $ query2;