From: "Susan Ator" <[EMAIL PROTECTED]>

> If I have a field in mySQL consisting of a number with 8 digits a decimal
> point and 4 more digits what is the field type it needs to be to sort it
> numerically?
>
> I've tried decimal(8,4) but it converts everything to 99999999.9999. I've
> also tried float but it doesn't sort numerically. All of the other integer
> types cut off the decimal bit.
>
> Any help would be appreciated.

What's this got to do with PHP?

Read here: http://www.mysql.com/doc/en/Numeric_types.html

---John Holmes...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to