Re: Displaying Numerals & Dates

2004-06-26 Thread Wesley Furgiuele
David: Sorry. I wrote that out poorly. I missed the closing parenthesis on the foreach(). Here it is in a cleaned-up form: Oh, also, you could/should zero out your mktime( ) function so looks like this (although it's not terribly important): mktime( 0, 0, 0, $month, $day, $year ); Apparently

Re: Displaying Numerals & Dates

2004-06-26 Thread David Blomstrom
--- Wesley Furgiuele <[EMAIL PROTECTED]> wrote: > Otherwise, you could use PHP's date formatting > functions as well > (assuming you are getting the date in -MM-DD > format: > foreach( $data as $r { > list( $year, $month, $day ) = explode( "-", > $r['Dates'] ); > $formatted_date

Re: Displaying Numerals & Dates

2004-06-26 Thread Wesley Furgiuele
David: For number formatting, in your below example, use: 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']

Displaying Numerals & Dates

2004-06-26 Thread David Blomstrom
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 rewrit