I was having trouble importing a particular csv file into a MYSQL table, so I designated most of the fields VARCHAR. Now that all my data is finally in the table, I'm weeding out various mistakes and redesignating the fields. But I'm hung up on a numerical field which features 1) some numerals that require commas and 2) variable decimal places.
It appears to have a maximum of about 12 characters, with anywhere from 0-2 decimal places. It could include any of the following numerals: 1002 124.5 64.12 14025.1 This is how I designated it in my table: decimal(10,2) But the decimals are no longer displaying. I'm using the following code on my webpage to display commas: <td>" . number_format($row['MilAvail']) . "</td> Does anyone know what I have to do to display 1,024.05, rather than 1,024? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
