<i><b>Originally posted by : Jimmy (jimleow@maxis.net.my)</b></i><br /><br />Hi,<br /><br />I'm currently developing a web site. I want to know whether it is possible to deduct any amount in the database, say, for instance money. Suppose a person is buying a product at $2 and the balance in the database is $500. How can I make sure that exactly $2 is deducted from the $500, which is supposed to yield a value of $498 in the database. I know about update query but it simply won't work in my case. I hope someone can show me the way to get through that. Thanks in advance.<br />