sum fields in php

[glenna1984]

I have a table that looks like:

 

A int(1)

B int(1)

C int(1)

total int(2)

 

In my php code I want to put a line that will update the field total as the sum of A + B + C

 

I know it is simple, but I cannot get seem to get it right.

 

Thanks,

Glenn

[trq]

UPDATE tbl SET total = a+b+c;

[glenna1984]

That works perfectly in mysql.

 

To put that into a .php file, however, don't I need to add something like mysqlXXXX() ?

[psychowolvesbane]

$SQL = "UPDATE tbl SET total = a+b+c";

$RSUpdate = mysql_query($sql,$conn);

 

$conn is your MySQL connection queries.

[glenna1984]

Thanks!