MadTechie Posted April 10, 2007 Share Posted April 10, 2007 OK this should be simple but again i have messed up somewhere, i have review my "O'Reilly's MySQL Pocket Referance.. :-\" but its not much help.. OK the problem Table1 Field A Field B Field C All Type Float Now Field A = 140 Field B = 211 Field C = 0 i run the SQL statement UPDATE `Table1` SET `Field C` = ((`Field A`/`Field B`)*100 ); and Field C becomes ...150.714... surely that shoud be 66.666.....? can someone please help me workout what i am doing wrong.. Link to comment https://forums.phpfreaks.com/topic/46399-adding-fields/ Share on other sites More sharing options...
wildteen88 Posted April 10, 2007 Share Posted April 10, 2007 I get 66.3507 as the result. When I run the above query on a test table I set up. What data types do you have set? fieldA and fieldB should be INT and fieldC should be FLOAT Link to comment https://forums.phpfreaks.com/topic/46399-adding-fields/#findComment-225661 Share on other sites More sharing options...
MadTechie Posted April 10, 2007 Author Share Posted April 10, 2007 Field A and B may need to be Floats, Strange i just created another table and it works but the old table still fails.. i am trying to work out why! Will try to rebuild the old table, if it fails i'll post it OH one other thing, the Fields used in this calculation were Text but i converted them (before trying the calculation) Link to comment https://forums.phpfreaks.com/topic/46399-adding-fields/#findComment-225668 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.