This has been resolved. A previous programmer had snuck in a function that
would convert the value of the description field to a date value if it
contained the word Date. This has been fixed.
On Tue, Feb 14, 2012 at 5:44 PM, David Robley robl...@aapt.net.au wrote:
Richard S. Crawford wrote:
Bear with me here. I have a problem with PHP and MySQL that's been
stumping me for a couple of days now. I'm not even sure how to describe
it, so I'll just do my best.
There's a row in our bugs database that looks like every other row in the
table, but when it's pulled from the database and displayed in PHP, the
description field -- which is defined as a mediumtext field -- is
displayed as a date field with a value of 12/31/1969. Moreoever, when I
use PHPMyAdmin to look at the row directly, the description field has
the data that I expect it to.
Just for fun, here's the text in question:
Quarterly Course Set Up - Spring 2012 (114)
Section Course titleCourse Start
Date
114MHI214 The Internet and the Future of Patient Care 04/02/2012
114MHI212 Health Information Systems Analysis and Design 04/02/2012
Program administrator 2 users; Laurel Aroner - Susan Catron - Jennifer
Kremer
Instructors;
MHI214; Peter Yellowlees
MHI212; Robert Balch
Per instructions from Rita Smith-Simms - I'm creating this task for
myself
and based on instructions given which are that all listed courses are now
to be backed-up and restored sooner (original course set up time-frame
was
a month before course starts).
Adding instructions - Follow the 52-step quarterly course set up process
and information from the course matrix; if matrix incomplete, input
information during this set up
As you track your time each day, please include in the notes which
courses
(use project code) you worked on and indicate either working on or
completed.
Create and notify by 2/15/2012
I've made sure there are no odd characters that would mess up how PHP is
displaying the text. I've tried changing the field type from mediumtext
to text but this didn't work.
If anyone has any ideas as to why this might be happening -- or if I just
wasn't clear -- please let me know.
If phpmyadmin gives expected results and _your_ code doesn't, I'd be
suspicious of your code :-)
It might be helpful for you to post relevant part(s) ofthe actual code you
are using.
Cheers
--
David Robley
Man who run behind car get exhausted.
Today is Sweetmorn, the 46th day of Chaos in the YOLD 3178.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Sláinte,
Richard S. Crawford (rich...@underpope.com)
http://www.underpope.com
Publisher and Editor in Chief, Daikaijuzine (http://www.daikaijuzine.com)