
June 28th, 2001, 03:35 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
Value deduction from database
<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 />
|