Date: Tue, 19 Jul 2005 15:16:47 -0400
From: blackwater dev <[EMAIL PROTECTED]>
Reply-To: blackwater dev <[EMAIL PROTECTED]>
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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to