Code not working. MySQL.

[smithmr8]

Hi,

The following code doesn't seem to work. The first part, 'sday' works, however the 'bday' does not.

 

<?php
if($_GET['step'] == 'sday') {
if ($x['money'] >= 250) {
mysql_query("UPDATE users SET sdays = sdays+1 WHERE ID = $x[iD]");
mysql_query("UPDATE users SET money = money-250 WHERE ID = $x[iD]");
echo "You bought a Shareholder Day for £250.";
} else {
echo "You do not have enough money to buy one of these. Try working some more, bum.";
}
}

if($_GET['step'] == 'bday') {
if ($x['sdays'] > 0) {
mysql_query("UPDATE users SET sdays = sdays-1 WHERE ID = $x[iD]");
mysql_query("UPDATE users SET money = money+175 WHERE ID = $x[iD]");
echo "You sold a Shareholder Day for £175.";
} else {
echo "You do not have any Shareholder Days to sell. We aint no fools.";
}
}
?>

 

sdays = table field

 

The first part works perfectly. If the person has the money, then the updates take place. Else, it jumps to the else clause.

 

The second part however, seems to be jumping directly to the else clause, or something else is wrong.

 

 

[smithmr8]

OH, and the $x is all fine. It corresponds to this code in the header file.

 

$user = $_SESSION['myusername'];
$info="SELECT * FROM users WHERE username='$user'";
$result_info = mysql_query($info);
$x=mysql_fetch_array($result_info);

[Barand]

try

 

echo $x['sdays'];

 

and check the value

[smithmr8]

Its decided to work now. I'm not sure why it wasn't working before, but all seems well now.

 

[Barand]

For future reference, this rule still holds true

 

"If the output isn't what you expected, check the input"

[smithmr8]

Yeah. Thanks.