Here, update chooses bal(for balance) column of register table whose is to be changed to difference of bal and the value in variable $tax for only the row saisfying the condition. It's not working in following code.How to do it?
$query3 = mysql_query('update table register set bal=bal-'.$tax.' where name='.$user.')' , $connection);