p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   online payment (http://p2p.wrox.com/showthread.php?t=38684)

p2ptolu February 19th, 2006 11:53 AM

online payment
i will like to develop an application that allows users to buy a card and type in the PIN number and the person's account will be refilled.

i need help on this how do i implement it because if i enter the pin it overwrites the existing amount online.

how do i add the amount to the amount online.

nalla February 24th, 2006 05:54 AM

I assume you have a problem with your update SQL when updating the user account. Check your SQL you execute when updating user account. It should be like this.

UPDATE [tablename] SET [fieldname]=[fieldname]+newamount WHERE [condition]

This will over write the current value
UPDATE [tablename] SET [fieldname]=[fieldname] WHERE [condition]

nalaka hewage

All times are GMT -4. The time now is 06:43 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.