RE: [PHP-DB] php maximum characters in text field
| From: | Instruct ICC | Date: | Mon, 15 Oct 2007 17:05:27 +0000 |
| Subject: | RE: [PHP-DB] php maximum characters in text field | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44215@lists.php.net to get a copy of this message | ||
> 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_oct