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;