SQL Statement Help!

[matvespa]

I thought there is nothing wrong with this SQL statement. Anyone can spot any mistake? Because i receive this error when i upload it onto my server

 

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

 

$result = "Update auctiontransfer SET AuctionRate = " . $AuctionRate . "  where ID = " . $ID;

[Wolphie]

$AuctionRate is a string, so you need to surround it in quotes.

 

$result = "UPDATE auctiontransfer SET AuctionRate = '". $AuctionRate ."' WHERE ID = ". $ID;

[PFMaBiSmAd]

Echo $result so that you can see what is wrong with it. The error you got is typical of the numerical variable on the end of the query being empty.

 

If the AuctionRate column is a numeric data type, you would not want to enclose it in single-quotes in the query, especially if it is a DECIMAL data type as the single-quotes force a conversion to a FLOAT value, which can result in a floating point conversion error that the direct input of a DECIMAL data value would not have.