in reply to Bizzare comma bug

If "new price = 23356.00"
then why "UPDATE items SET price='23501.35' WHERE itemref='S10099';"
?

The bug is not in removing the comma. It is elsewhere in your code.