Hi everybody,
I am facing problem querying MySQL tables with PHP. Actually I have a field in a table with float data type. In one record i've value 2.95 in the float field. When I retrieve and print it from PHP code, it prints 2.9500000476837. I know it's 'coz data type is float and there are few precision issue involved. But when i run the following query from PHP ==>
"SELECT FROM url_keywords WHERE bid = 2.95"
or
"SELECT FROM url_keywords WHERE bid = 2.9500000476837"
I get nothing in both case. Please help me. Waiting for ur response.
Regards
Ashish