house tax

[montyash]

my house tax takes the money away everyday but if you have no money it doesnt go into minuses can anyone help

[-Matt-]

Re: house tax

1. Change your crons

2. No idea.

[Guest Anonymous]

Re: house tax

Maybe something like...

 

<?
if($ir['money'] < 0)
{
exit;
} else {
//do code
}
?>

[AlabamaHit]

Re: house tax

If its NOT going into the minus you must have a

WHERE clause in the query that prevents it....

So (Just an example)

I would guess you have this

$db->query("UPDATE users SET money=money-$tax WHERE money > 0");

For this to take them in the negative just take the WHERE out...

Example...

$tax = 5000;

$db->query("UPDATE user SET money=money-$tax");

That would go on ALL users....Im sure your error is in the WHERE cluase of the query running.