[SOLVED] MySQL Update query failng

[joecooper]

                      $query = "UPDATE users SET high = $score WHERE username = $username";

                      mysql_query($query) or die('Error, query failed');

 

can someone tell me why this might be failing

[AndyB]

Try

$query = "UPDATE users SET high = '$score' WHERE username = '$username'";
mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query); // helpful err message

[dooper3]

Use quotes:

 

$query = "UPDATE users SET high='$score' WHERE username='$username'";
mysql_query($query) or die('Error, query failed');

 

Other stuff to do...

 

-check you are connected to the database

-check the table columns "high" and "username" exist

-check the variables $score and $username actually exist

 

If all else fails, show us the actual error message

[joecooper]

ah it works thanks