Re: mySQL field structure question
| From: | CPT John W. Holmes | Date: | Wed, 01 Oct 2003 15:44:09 +0000 |
| Subject: | Re: mySQL field structure question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30792@lists.php.net to get a copy of this message | ||
From: "Susan Ator" <SAtor@npr.org>
> 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...