|
|
Posted by Marek Kilimajer on 07/20/05 00:49
Paul Waring wrote:
> On Tue, Jul 19, 2005 at 09:50:06AM -0700, George B wrote:
>
>>My money is being stored in a database. And I want everythign to be in
>>PHP, no java script. And the BUY!! Button is a input button from a form. :)
>
>
> Well in that case you probably want something like this (after you've
> checked to see whether the user is logged in etc):
>
> $sql = "UPDATE users SET money = money - 10 WHERE id = " .
> $_SESSION['user_id'];
this does not check if the user has enough money. This query does:
UPDATE users SET money = money - 10 WHERE id = $_SESSION['user_id'] and
money >= 10
Then check affected rows to see if the money was actually subtructed
from the account.
Navigation:
[Reply to this message]
|