Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[KyleMassacre]

Im having an issue with members recieving interest in their donator bank I could swear ive tried everything and nothing works. This is what I have set up in my cron day, can someone please help?

$db->query("UPDATE users SET donatorbank=donatorbank+(donatorbank/100*6) where > 0");

[Cronus]

Code: [Select]

$db->query("UPDATE users SET donatorbank=donatorbank+(donatorbank/100*6) where > 0");
the problem is this:

Code: [Select]

where >0
you have nothing before the >0, where what is greater than 0? that should probably be:

Code: [Select]

where donatorbank>0

[KyleMassacre]

Alright thanks, its always the obvious that gets me haha