jaxdevil Posted November 19, 2012 Share Posted November 19, 2012 I've been trying to come at this problem from multiple angles and can't seem to figure it out. I have my update statement and it updates the other fields but not the field that is set as a decimal(20,5) type. I have tried formatting the number to be 5 decimal places, padded left with zeros so it is 20 characters long with 5 decimals, but it will not update. I can copy the query into phpmyadmin and run the update statement and it works fine, but in php it will update every field that is modified within the exact same query but not the decimal(20,5) field. Any ideas how to get around this issue? Thanks in advance to anyone who can help here. Quote Link to comment https://forums.phpfreaks.com/topic/270909-problem-updating-a-decimal205-field-in-mysql-via-php/ Share on other sites More sharing options...
Pikachu2000 Posted November 19, 2012 Share Posted November 19, 2012 Code? Quote Link to comment https://forums.phpfreaks.com/topic/270909-problem-updating-a-decimal205-field-in-mysql-via-php/#findComment-1393599 Share on other sites More sharing options...
fenway Posted November 21, 2012 Share Posted November 21, 2012 Echo the query. Quote Link to comment https://forums.phpfreaks.com/topic/270909-problem-updating-a-decimal205-field-in-mysql-via-php/#findComment-1393987 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.