RE: [PHP-DB] 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@otc.fsu.edu> To: Bastien> instructicc@hotmail.com; php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in Bastien> text field> > It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get Bastien> made in the d'base... the confirmation email went out, but wherever info was supposed to kick Bastien> back from the d'base (ie. Order number), it showed an "undefined variable" error.> Bastien> > -----Original Message-----> From: Instruct ICC [mailto:instructicc@hotmail.com] > Sent: Bastien> Monday, October 15, 2007 1:05 PM> To: php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum Bastien> characters in text field> > > > I am starting to believe it is NOT the character length Bastien> that is causing the problem. We have received other orders with more in it than that, and they came Bastien> in ok. I think there may be something in the input that php does not like. I've been searching Bastien> for code that will "clean up" input, possibly preg_replace?> > Was the order Bastien> received, but the text was shorter than expected?> Or was the order not "received" at Bastien> all?> > Check your mysql query log. It may show failed queries where bad characters made the Bastien> query fail, perhaps using ' or "?> Use mysql_real_escape_string.> Bastien> _________________________________________________________________> Climb to the top of the Bastien> charts! Play Star Shuffle: the word scramble challenge with star power.> Bastien> http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct> Bastien> -- > PHP Database Mailing List (http://www.php.net/)> To unsubscribe, visit: Bastien> http://www.php.net/unsub.php> > -- > PHP Database Mailing Bastien> List (http://www.php.net/)> To unsubscribe, visit: Bastien> http://www.php.net/unsub.php> _________________________________________________________________ Express yourself with free Messenger emoticons. Get them today! http://www.freemessengeremoticons.ca/?icid=EMENCA122