[Resolved] Update Problem

[cassius]

I can't update a double field in my db, but all other fields can be updated using the same sql...

$sql = "UPDATE Phonerecs SET 0305='$gil' WHERE nummer='$number'";
$var = mysql_query($sql) or die("Error: ".mysql_error());

0305 is a double(4,2) field.

The error message I get is:

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 '0305='9.5' WHERE nummer='33030203'' at line 1

Anyone know what the problem is ??

[mrhappiness]

try

`0305` = $gil

[cassius]

Hi.
I finally solved my problem after a lot of testing. I can't actually see why this solved the problem, but at least it's working now so I guess that makes me happy(??).

My original sql:

$update = "UPDATE Phonerecords SET 0305=$gil WHERE number=$number";

That didn't work, but my new and improved sql worked fine:

$update = "UPDATE Phonerecords SET Phonerecords.0305=$gil WHERE number=$number";