turst Posted December 8, 2006 Share Posted December 8, 2006 Is it not possible to have a WHERE clause check if something is equal to a float? I've tried it with both x = 5 and x = 6 and both work, so my query is fine other than this last part. When i use any number with a decimal, I get no results. 5.19 is a valid piece of data so it should be able to find it. Is there a way around this?Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/29874-where-x-519-why-doesnt-this-work/ Share on other sites More sharing options...
drifter Posted December 8, 2006 Share Posted December 8, 2006 try quotes??? Quote Link to comment https://forums.phpfreaks.com/topic/29874-where-x-519-why-doesnt-this-work/#findComment-137282 Share on other sites More sharing options...
turst Posted December 8, 2006 Author Share Posted December 8, 2006 i've tried every combination of single quotes. do you used double quotes? Quote Link to comment https://forums.phpfreaks.com/topic/29874-where-x-519-why-doesnt-this-work/#findComment-137462 Share on other sites More sharing options...
turst Posted December 8, 2006 Author Share Posted December 8, 2006 ok, i found that the problem is the inaccuracy in the float. i ended up having to do a < 5.20 AND > 5.18 Quote Link to comment https://forums.phpfreaks.com/topic/29874-where-x-519-why-doesnt-this-work/#findComment-137506 Share on other sites More sharing options...
drifter Posted December 8, 2006 Share Posted December 8, 2006 makes sence - whenever I use float, I do use quotes... but I also use < or > Quote Link to comment https://forums.phpfreaks.com/topic/29874-where-x-519-why-doesnt-this-work/#findComment-137587 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.