oops my bad.
PHP Code:
// Start Rewards
// ************************************************
//Get currency on level up
$query = "SELECT * FROM `".$prefix."users` WHERE `username`='$loggedinname'";
$result = mysql_query($query);
$num = mysql_numrows($result);
$i = 0;
while ($i < 1) {
$dollar = @mysql_result($result, $i, "dollar");
// Change this number 10 to the number of currency you want users to earn on level up
$amount = rand(5, 15);
$newbalance = $dollar + $amount;
$i++;
}
mysql_query("UPDATE `".$prefix."users` SET `dollar`='" . $newbalance . "' WHERE `username`='$loggedinname'");
Try that. If that doesn't work, theres an inconsistency with your tables.