SQL help!

[kito2]

Hi, I need a command for SQL that update all premdays that have 0 to 7, without replacing the account that have premium days...

Like this for example:

UPDATE accounts SET premdays = premdays + 5 WHERE premdays != 0

This update al premdays that are not 0, and add 5 days... someone knows how to do what im asking for?

 

[mattyboi88]

Hi

Here is the code you need for your sql command

UPDATE accounts SET premdays = premdays + 7

Rep? ++

 

[kito2]

But it will add to players that have premdays :S

 

[kornholi]

.............

UPDATE `accounts` SET `premdays` =7 WHERE `premdays` =0

use logic.

 

[kito2]

Thanks, repped+!