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 title Course 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)
