Update Problem

[Chevy]

For some reason none of my data in MySQL is updating.

 

Is there something wrong with this code?

 

 

  $plusone = $info['attempts']+1;

    $updatea = mysql_query("UPDATE `accounts` SET `attempts`='$plusone' WHERE `username`='$username'");

     $owed = (10*$info['attempts'])+20;
     $newpoints = $info['points']-$owed;

          if ($newpoints < "0"){
             $newpoints = 0;
          }
               $updateb = mysql_query("UPDATE `accounts` SET `points`='$newpoints' WHERE `username`='$username'");

[shocker-z]

Try adding or die(mysql_error()) after running mysql_query

 

e.g.

 

  $plusone = $info['attempts']+1;

    $updatea = mysql_query("UPDATE `accounts` SET `attempts`='$plusone' WHERE `username`='$username'") or die(mysql_error());

     $owed = (10*$info['attempts'])+20;
     $newpoints = $info['points']-$owed;

          if ($newpoints < "0"){
             $newpoints = 0;
          }
               $updateb = mysql_query("UPDATE `accounts` SET `points`='$newpoints' WHERE `username`='$username'") or die(mysql_error());

 

this will produce an error message stating where your error is.

 

 

Regards

Liam

[Chevy]

I do not get anything when I do that :?

[teng84]

what are the datatypes of those fields your trying to update

[Chevy]

They all are numerical values, if that is what you mean.

[teng84]

if you mean numeric values as int in your DB then you cant add any single ' in your set value

`attempts`='$plusone'  this will be invalid it should be

`attempts`=$plusone to tell the Db that it is actaully a numeric value so when you put ' it will be treated as string or char that wont match your fields datatypes

[BlueSkyIS]

i use single quotes for EVERY database column regardless of type, at least in MySQL. single quotes around a numeric value will not affect how that value is inserted or updated, but it may prevent having malicious code inserted into your database.

 

add: i don't think the problem is data types. i think that the data you are using to update is wrong. can you write your sql to a variable and echo that variable?

[Chevy]

Ah, okay, ill give that a try

 

Edit: I have also tried echo-ing the data, it all is what it is supposed to be, yet it will not update.