Floats don't work but ints do!

[Anon]

I have a MySQL table that uses a float type for one of its columns. Some of the values can also be integers. Simple, right?

When I do a query against this table, queries for ints work fine, but they don't work at all for floats:

$sql = "SELECT * WHERE MyCol = 5.6" does not work.

But $sql = "SELECT * WHERE MyCol = 5" does.

I have declared this column as a float type with the parameters (2,1) as the column numbers will never exceed 99.9.

This should be a no-brainer, but I can't get the query to work. The result set returns nothing for records with floats in that column! Gotta be some hidden spec somewhere.

A search of the MySQL docs and PHP has turned up nothing.

[pnoeric]

stinger - dunno the exact answer but have you tried the sql querys in a mysql front ejnd (like MySQL Front or PHPMySql)? At least that would let you know if the problem is in PHP or MySQL.

best
Eric

[Anon]

Yes, I can try it from MySQL Front, which I use sometimes. I suppose I could also go to my DOS window and do it in the Monitor.

One curious thing, I changed the data type from float to varchar, and now the query works! Of course, that is not the correct data type, but it's a patch until I get this figured out.

[mfueger]

As far as I know you can't do an equal comparison on a float. -- See the mySQL manual.