PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Hey
my problem is, i need to have one field in my database that is constantly updating.
This field has to be a sum from several fields in the same table.
I dont know if it ispossible, to have a field that includes an insert command and is constantly running this command.
If that is the way to solve the problem the insert has to be like this:
INSERT INTO sam_bestellung.contrvalue VALUES ('sam_date_val.cortval1'+'sam_date_val.cortval2'+'sam_date_val.cortval3') FROM sam_date_val,sam_bestellung WHERE customernr='02.01.' AND projnr='302
So in this example it means, when contrval1-3 chages contrvalue also changes.
I hope you understand my problem!?!
joe