Can't replicate this unfortunately, I don't have mysqli installed (for whatever reason) on my works dev machine.
Something is rounding it somewhere, I'll bet its mysqli, just try dumping it as a string type I don't think mysql will mind if it has quotes around it or not. Failing that there must be some form of rounding error at mysql's end, try specifiying the mantissa/exponent in the float args:
ALTER TABLE `stations` MODIFY COLUMN `lat` FLOAT(6,3) DEFAULT NULL;
ALTER TABLE `stations` MODIFY COLUMN `lon` FLOAT(6,3) DEFAULT NULL;
If not I'll have to wait to get home and try mysqli on my home web server.
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
The Following User Says Thank You to sketchMedia For This Useful Post:
Btw, for anyone who wants to know how I got around this... I changed it to a double instead of float and it worked. Don't use the above alter table or it messes things up too. Just make sure you use 'd' when binding.
I am not a programmer, nor do I play one on tv.