Re: [PHP-DB] mySQL field structure question

2003-10-01 Thread CPT John W. Holmes
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 .. 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



[PHP-DB] mySQL field structure question

2003-10-01 Thread Susan Ator
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 .. 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.

Susan

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