Complicated script that just wont work

[TheRealPenguin]

ok im making a browser based game and i wnated to add stocks as one of the feature so i made a random function that ran on a cron to control the up down value and now im trying to add purchasing of stocks here is my code

//buy stock #1
if ($_GET['buy']==true1){
if($a<=$money){
$st = $_1stock + 1;
$oney = $money-$a;
$val = $a*.10;
$net = $networth+$val;
$stock = "UPDATE UserDetails set networth='$net', money='$oney', 1='$st', value1='$a'
where ID='$id'";
        mysql_query($stock) or die ("Could Not Buy Stock");
echo "You Just Bought Stock #1 for $$a";
}
else {
  echo "You There Aint Got Enough Money";
}
}
//end stock #1

now all the varibles are being pulled from a config.php page which i have included farther up in this page.
When i hit the submit button which sets buy==true1 i get the message Could Not Buy Stock not sure whats wrong with the script any help would be greatly appreciated since im on a deadline on the game

[Swardh]

try to add some quotes in your if-statement

if ($_GET['buy']=="true1") {

[TheRealPenguin]

yeah but thats not it its not in any of the others its a problem with my sql not my if statement

[leatherback]

Hi,

Not sure wether it is messing your code up but.. I do not think that numbers need quotes in sql statements.
Anyway. Easiest way to solve these issues is by echo-ing the actual SQL string to screen, and then running the command in your database-manager (e.g., mysqladmin) interface directly. THat will show you:
- Whether the commands are correct
- Whether the variables pass into the query
- WHat the error is

Also: Add a die(mysql_error()) to the end of your query when de-bugging.

J.