Re: Displaying Numerals & Dates - Wesley Furgiuele - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Displaying Numerals & Dates

From	Sent On	Attachments
David Blomstrom	26 Jun 2004 17:47
Wesley Furgiuele	26 Jun 2004 18:44
David Blomstrom	26 Jun 2004 19:18
Wesley Furgiuele	26 Jun 2004 19:43

Subject:	Re: Displaying Numerals & Dates
From:	Wesley Furgiuele (wes...@furgiuele.net)
Date:	06/26/2004 06:44:18 PM
List:	com.mysql.lists.mysql

David:

For number formatting, in your below example, use: <?php foreach( $data as $r ) { print number_format( $r['Numerals'] ); } ?> http://us2.php.net/manual/en/function.number-format.php

For date formatting, try grabbing the date from MySQL in the format you want to use: SELECT DATE_FORMAT( date_field, '%M %D, %Y' ) AS `Dates` FROM ... and then just print $r['Dates'] would work. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Otherwise, you could use PHP's date formatting functions as well (assuming you are getting the date in YYYY-MM-DD format: <?php foreach( $data as $r { list( $year, $month, $day ) = explode( "-", $r['Dates'] ); $formatted_date = date( "F jS, Y", mktime( 21, 39, 0, $month, $day, $year ) ); print date( "F jS, Y", $timestamp ); } ?> http://us2.php.net/manual/en/ref.datetime.php

As for the imported numbers showing up as they are, perhaps you are importing them into SMALLINT field, which has an upper signed limit of 32767. Try changing your field type to INT or MEDIUMINT, depending on the range of numbers imported, and whether or not there are any negatives. http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html

Wes

On Jun 26, 2004, at 8:47 PM, David Blomstrom wrote:

I asked some questions about displaying numerals and dates recently and got some good feedback. Now I'm ready to do it - but I'm doing something wrong.

Consider the table below, where the field "Numerals" displays regular numerals (e.g. 2500) and "Dates" displays dates.

Exactly how would I rewrite this so that commas are inserted in numerals (2,500 vs 2500), and dates (e.g. 2004-12-28) are displayed like "December 28th, 2004," or "Dec. 28, 2004"?

<table class="sortable" id="tab2000"> <tr><th class="tabstate" colspan="8">Campaign 2000</th></tr> <tr>

</tr> </table>

Also, there's something really weird going on with my numerals. I saved a Microsoft spreadsheet as a CSV file, which I then imported into MySQL.

But many of the numerals were transformed to 32767 in my database. Here's a sample line from the CSV file, which illustrates that just one numeral is surrounded by quotes:

921781,"472940",422768,13421,7358,5294

In this particular example, the last two numerals display correctly in the database, but the other four don't - including the numeral surrounded by quotes.

Any idea what's going on here? Thanks.