Counting values in different tables

[internethuwelij]

Hello,

I have 3 tables in MySQL, named table1, table2 and table3

Now i want to add table4 and dynamic fill it with the result from table1+table2+table3

So for example in row1 i have the values:
in table1: 100
in table2: 50
in table3: 150

the value in table4 should be automatic set to 300

Anyone know how to do this? Can i do this directly in MySQL or do i need a phpscript?

Thanks for your support.

[LordShryku]

MySQL does not support triggers yet, so you would be best off writing a php script to do this for now

[helz]

$field = $fieldfromtb1 + $fieldfromtable2 + $fieldfromtable3;
mysql_query("INSERT INTO table4 (field) VALUES ('$field')");