[SOLVED] Problems with Update SQL

[wwfc_barmy_army]

Hello. I can't figure out what is wrong with my SQL code, but it keeps failing

 

  $query = "UPDATE previous SET (count = count +1, reasons = $newreason) WHERE username = '$username'";
  echo $query;
   mysql_query($query) or die('Error, query failed');

 

Currently outputting:

UPDATE previous SET (count = count +1, reasons = ftugsdt

- sdfgd) WHERE username = 'TUSER'  Error, query failed

 

Thanks for any help.

[PFMaBiSmAd]

Change your or die() statement to the following to get mysql to tell you why -

 

or die('Error, query failed' . mysql_error());

 

I'm going to guess that reasons is a string data type, if so than the value being put into it must be enclosed in single-quotes to make it a string.

[wwfc_barmy_army]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(count = count +1, reasons = 'ftugsdt

- dasfdsfsd') WHERE username = 'TUSER' at line 1

 

 

and if i take the new line out of $newreason:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(count = count +1, reasons = 'ftugsdt - sdfgds') WHERE username = 'TUSER'' at line 1

 

Any ideas?

 

Thanks.

[PFMaBiSmAd]

Remove the "(" and ")" from around the SET statement.

[wwfc_barmy_army]

Thanks