matvespa Posted March 16, 2010 Share Posted March 16, 2010 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; Link to comment https://forums.phpfreaks.com/topic/195415-sql-statement-help/ Share on other sites More sharing options...
Wolphie Posted March 16, 2010 Share Posted March 16, 2010 $AuctionRate is a string, so you need to surround it in quotes. $result = "UPDATE auctiontransfer SET AuctionRate = '". $AuctionRate ."' WHERE ID = ". $ID; Link to comment https://forums.phpfreaks.com/topic/195415-sql-statement-help/#findComment-1026881 Share on other sites More sharing options...
PFMaBiSmAd Posted March 16, 2010 Share Posted March 16, 2010 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. Link to comment https://forums.phpfreaks.com/topic/195415-sql-statement-help/#findComment-1026886 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.