So using select sum(points) as score from this will also add a minus value.

How can I get around this and have it subtract that value.

Cheers

Ibbo

Scrap that,

Weird DB behaviour when i use type int it passes it as a string, but when i use type integer I get an int. So now sum actually subtracts (by adding) negative numbers) which it would not do as an int.

Bizarre

Ibbo

Maybe you set the column to be unsigned ?

mysql> select version();
+-----------+
| version() |
+-----------+
| 4.0.20    |
+-----------+
1 row in set (0.01 sec)

mysql> create table t (t int default 0);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t values (1),(2),(3),(-3);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0


mysql> select * from t;
+------+
| t    |
+------+
|    1 |
|    2 |
|    3 |
|   -3 |
+------+
4 rows in set (0.00 sec)

mysql> select sum(t) from t;
+--------+
| sum(t) |
+--------+
|      3 |
+--------+
1 row in set (0.00 sec)