[skiplovebra]

Currently I want to use sql language in navicat set for membership account on level 3 gets 200 credits How to use code like? My plevel and pcredits

[TheToretto]

PHP код:

 UPDATE yourtable SET pcredits='200' WHERE plevel ='3'; 


[skiplovebra]

Quote:

Originally Posted by TheToretto PHP код:  UPDATE yourtable SET pcredits='200' WHERE plevel ='3';

I have done successfully but I want to add more as I did not do
UPDATE `accounts` SET Credits +='200' WHERE Level +='3';

[TheToretto]

Rename your table to gtarp without the " - "

[skiplovebra]

Quote:

Originally Posted by TheToretto Rename your table to gtarp without the " - "

I want to implement add value but not?
UPDATE `accounts` SET Credits +='200' WHERE Level +='3';

[skiplovebra]

Done
Close topic
thanks

[TheToretto]

What I understood is to set players with only the level 3, 200 Credits.

If you want to increment the values of ALL players with no condition, you can do that:

pawn Код:

UPDATE accounts SET pcredits= pcredits + 1, plevel = plevel + 1;