The MySQL SUM function takes the fields or rows you input and adds their values together, then returns the total. Save your query in a PHP variable. You can use the function as many times as you ...

Hiya,I want to update in one table dependant on the contents of another table, like;UPDATE table1 set column1 = '0' where table2 column2 ...