Hello.
> I designated a field Decimal 3,1. When I put a PHP
> query on my page, it displayed 450 as 450, but it
> rounded the fractions off, turning 24.8 into 25.
I think - the problem is in number_format() function. From the PHP manual:
"If only one parameter is given, number will be formatted without decimals."
David Blomstrom <[EMAIL PROTECTED]> wrote:
> I apologize if this is a double post, but it appears
> that my first message didn't transmit for some reason.
>
> Anyway, I'm having a weird problem with decimals.
> Imagine a field with just two numerals - 450 and 24.8.
> You want to display them as 450 and 24.8, not 450.05
> and 24.8 or 450 and 3.
>
> I designated a field Decimal 3,1. When I put a PHP
> query on my page, it displayed 450 as 450, but it
> rounded the fractions off, turning 24.8 into 25.
>
> So I went back to my spreadsheet and changed every
> cell to TEXT before exporting it into a new CSV file.
> I imported it into MySQL but got the same results.
>
> Next, I changed the field to Char 3, emptied the table
> and re-imported the CSV file. To my amazement, I get
> the same results.
>
> Yet when I browsed my table in phpMyAdmin, I saw the
> data displayed as 450 and 24.8, just like I wanted. So
> I can't figure out why it doesn't display like that.
>
> Actually, I'd like to change it just a bit. This table
> focuses on geological time. Rather than translate
> everything into a common unit (millions, billions,
> etc.), I decided to use both millions and billions and
> distinguish them by font color.
>
> For example, a yellow 2.5 would represent 2.5 BILLION,
> while a white 340 would represent 340 MILLION. The
> only remaining problem is the end of the Ice Age,
> 10,000 years ago. That would equal .01 million years.
>
> Still, I ought to be able to handle this with a Char
> or Varchar, shouldn't I?
>
> This is the script I'm using to display it, where
> YearBegan and YearEnded equal the beginning and ending
> dates of various geological periods:
>
> echo '<table class="sortphp" id="tab_geotime"
> style="font-size: 85%; line-height: 130%;">
> <tbody>';
> //<!-- BeginDynamicTable -->
> while ($row = mysql_fetch_array ($res)) {
>
> // and add this in your while loop:
> $YearBegan_arr[] = $row['YearBegan'];
> echo "<tr class=\"". $row['IDParentTime'] ."\"
> id=\"". $row['IDTime'] ."\"><td class=\"name\"><a
> href=\"javascript:;\"onclick=\"MM_openBrWindow('/time/bits/".$row['IDTime'].".php','TimeHelp','menubar=yes,scrollbars=yes,resizable=yes,width=300,height=250')\">
> ". $row['NameTime'] ." ". $row['TimeType']
> ."</a></td>
> <td class=\"date\">" .
> number_format($row['YearBegan']) . "-" .
> number_format($row['YearEnded']) . "</td>
> <td class=\"border\"></td></tr>\n";
> $nameTypes[]=$row['NameTime'];
> }
> }
> ?>
> </tr>
> </tbody>
> </table>
>
> Thanks for any insights.
>
>
>
>
> __________________________________
> Celebrate Yahoo!'s 10th Birthday!
> Yahoo! Netrospective: 100 Moments of the Web
> http://birthday.yahoo.com/netrospective/
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
