Strahan Posted May 29, 2010 Share Posted May 29, 2010 This is aggravating the heck out of me. I made a web based checkbook so I can update it on the fly with my BlackBerry. The table has an "amount" field that I set to double. This is one record: Now when I go to do a select to find it by amount, I get this: Nothing. ??? Does this have something to do with having used double? I don't understand why it's failing to find it. Link to comment https://forums.phpfreaks.com/topic/203246-pulling-my-hair-out-help-me-stop-going-bald-lol/ Share on other sites More sharing options...
PFMaBiSmAd Posted May 29, 2010 Share Posted May 29, 2010 You should be using DECIMAL data type - http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html Link to comment https://forums.phpfreaks.com/topic/203246-pulling-my-hair-out-help-me-stop-going-bald-lol/#findComment-1064893 Share on other sites More sharing options...
Strahan Posted May 29, 2010 Author Share Posted May 29, 2010 Thanks! Link to comment https://forums.phpfreaks.com/topic/203246-pulling-my-hair-out-help-me-stop-going-bald-lol/#findComment-1065001 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.