This may be the issue:
PHP Code:
if($_GET["payclix"])
{ $newclix = $clix - $clixprice;
mysql_query("UPDATE users SET clix = '".$newclix."' WHERE username = '$loggedinname'");
$i++;
echo "clix: $clix balance: $newclix price: $clixprice name: $loggedinname";
}
elseif($_GET["paycash"])
{ $newcash = $cash - $cashprice;
mysql_query("UPDATE users SET cash = '".$newcash."' WHERE username = '$loggedinname'");
$i++;
echo "cash: $cash balance: $newcash price: $cashprice name: $loggedinname";
}
Mainly lines such as:
PHP Code:
mysql_query("UPDATE users SET clix = '".$newclix."' WHERE username = '$loggedinname'");
Should probably be:
PHP Code:
mysql_query("UPDATE ".$prefix."users SET clix = '".$newclix."' WHERE username = '$loggedinname'");
It simply looks like in a few of your queries you may be forgetting to use the table prefix for your database tables. :)
Let me know if that helps,
Brandon