MySQL queries ..?

[BMR777]

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