title: Web server transaction vs DB trigger - which is preferred?
body: <p>I would like to ask you for a situation that each value of two tables must be changed at the same time.</p>
  
  <p>There are two ways of the above, Web server transaction, DB trigger.</p>
  
  <p>Web server transaction is 100% safe? I am worried about a situation like one value of one table has been changed but another value of another table has not.</p>
  
  <p>I think DB trigger is safer than Web server transaction, but I use both of them due to the worries above.</p>
  
  <p>Also, I would like to ask you about DB procedure. Is it preferred? I prefer to use php codes and don't use it.</p>