[SOLVED] SQL Syntax Error?

[refiking]

Here is what the script returned:

 

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 'testuser'' at line 1

 

Here is the line they are referring to:

 

mysql_query("UPDATE dpicks SET first = '$num1' WHERE user = '$user'")or die(mysql_error());

[DarkerAngel]

...

 

try ticking your columns:

 

mysql_query("UPDATE `dpicks`SET `first`='$num1' WHERE `user`='$user'") or die(msql_error());

 

mod-edit. You don't need to quote all of a previous post.

[AndyB]

`backticks` might help if any of the variable names used had been MySQL reserved words, but as they're not backticks would be pointless.

 

For reference purposes - http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html

 

@refiking - are you sure that error report refers to the line you quote?

[DarkWater]

Do this for us please:

$query = "UPDATE dpicks SET first = '$num1' WHERE user = '$user'";

echo $query . '<br />';

mysql_query($query)or die(mysql_error());

 

Show us the error and the actual parsed query.  Thanks.

[refiking]

I found it guys sorry for taking so long to reply.  I have about 25 queries just like that 1.  The problem was I forgot the ' on one of them.  Thanks for your help!