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! 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??? 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? 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 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 > 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
Archived
This topic is now archived and is closed to further replies.