[HoussemGaming]

Hey all.
i wanna some help.
i wanna make something in mysql
example :
if in bank withdraw dialog the player have 200 in his bank account , he want withdraw 100, so the 100 will be deducted from the mysql table.
hwo to make that ? plz

[Abagail]

Deduct 100 from the current value. This is easy as an SQL statement:

pawn Код:

UPDATE players SET bank_cash = bank_cash - 100 WHERE UserID = %d

[HoussemGaming]

Oh thx abagail.
You helped me alot.
Thank you

[saffierr]

A possible better query would be (In other cases)

PHP код:

mysql_format(connectionHandle, query, sizeof query, "UPDATE players SET bank_cash = bank_cash - %i WHERE UserID = %i", withdrawn, yourUserVariable); 


I hope you got my tip :P

[HoussemGaming]

Quote:

Originally Posted by saffierr A possible better query would be (In other cases) PHP код: mysql_format(connectionHandle, query, sizeof query, "UPDATE players SET bank_cash = bank_cash - %i WHERE UserID = %i", withdrawn, yourUserVariable);  I hope you got my tip :P

Thank you