Here is the exact text he submitted: Please initiate phone lines in the following locations in the Leon County Civic Center to support our home Men's and Women's Basketball games. Meeting room B: activate 4 lines on the North Wall and 4 lines on the South Wall - all lines should have long distance with credit card only. Courtside: 1 - Please re-activate saved phone number 224-8790 along the West side press row. Please include long distance on the phone. 2 - Please activate the ISDN line on the East side scorer's table. 3 - Please re-activate the saved phone number 224-1155 on the East side scorer's table. Work room: Please activate 2 lines in the work room, one for telephone and one for fax. - Both with long distance capability Please call, e-mail or fax the telephone numbers associated with each location to Stuart Pearce at 644-4694 (office), 645-3278 (fax), spearce@xxxxxxxxxxxxxxx Thank you, Stuart Pearce -----Original Message----- From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx] Sent: Monday, October 15, 2007 1:48 PM To: VanBuskirk, Patricia; Instruct ICC; php-db@xxxxxxxxxxxxx Subject: RE: php maximum characters in text field Could it be an '&' ampersand in the data? Bastien> Date: Mon, 15 Oct 2007 13:29:02 -0400> From: pvanbuskirk@xxxxxxxxxxx> To: instructicc@xxxxxxxxxxx; php-db@xxxxxxxxxxxxx> Subject: RE: php maximum characters in text field> > It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the d'base... the confirmation email went out, but wherever info was supposed to kick back from the d'base (ie. Order number), it showed an "undefined variable" error.> > -----Original Message-----> From: Instruct ICC [mailto:instructicc@xxxxxxxxxxx] > Sent: Monday, October 15, 2007 1:05 PM> To: php-db@xxxxxxxxxxxxx> Subject: RE: php maximum characters in text field> > > > I am starting to believe it is NOT the character length that is causing the problem. We have received other orders with more in it than that, and they came in ok. I think there may be something in the input that php does not like. I've been searching for code that will "clean up" input, possibly preg_replace?> > Was the order ! received, but the text was shorter than expected?> Or was the order not "received" at all?> > Check your mysql query log. It may show failed queries where bad characters made the query fail, perhaps using ' or "?> Use mysql_real_escape_string.> _________________________________________________________________> Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power.> http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_o ct> -- > PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php> > -- > PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: http://www.php.net/unsub.php> _________________________________________________________________ Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
