[Solved] SQL Command

[mpa]

UPDATE players WHERE group_id=2 AND lastlogin < UNIX_TIMESTAMP() - 14*24*60*60 SET group_id=1

Can someone change this so it works?

 

[EvulMastah]

UPDATE players SET group_id= 1 WHERE group_id= 2 AND lastlogin < UNIX_TIMESTAMP() - 14*24*60*60

 

[mpa]

Thanks, Marc~!

 

[mpa]

I have a new problem:
What's wrong with this?

UPDATE accounts SET premdays+ 10 WHERE premdays> 1

 

[EvulMastah]

UPDATE accounts SET premdays = premdays + 10 WHERE premdays > 1

 

[mpa]

Thanks again!