Message-ID: <34a9824e05071912164a2ec9da@mail.gmail.com>
Date: Tue, 19 Jul 2005 15:16:47 -0400
From: blackwater dev <blackwaterdev@gmail.com>
Reply-To: blackwater dev <blackwaterdev@gmail.com>
To: php-db@lists.php.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Subject: floats
I am running a query on MySQL:
select * from cars where id =52
It returns the row and I can see that gas mileage is saved as a float
with a value of 23.45. So I then do a query, select * from cars where
id=52 and gas_mil=23.45 and the query doesn't retun anything. Why?
Do I have to cast this as a float?
Although it's possible that the float has a value of 23.4500000000000001, I wouldn't expect that to be an issue.
Instead, check that your gas_mil name is *exactly* that and not followed by a space (I've done it before !)
For example this SELECT * FROM cars WHERE gas_mil = 23.45
is NOT equivalent to SELECT * FROM cars WHERE gas_mil = 23.45
Notice the extra space in the column name.
If that doesn't work do a query for
SELECT * FROM cars WHERE id=52 AND gas_mil BETWEEN 23.4 AND 23.5
See what happens then,
Cheers - Neil