PHP Questions Home | Register | Login
Categories
Arrays
Files
Forms
Creating PDFs
PHP Errors
Functions
Images
MySQL
Numbers
Others
Strings
Website
Unanswered

PHP Forums
Forums Index
MySQL Forum
PHP Forum
Flash/Actionscript
Javascript
Web design

More PHP
PHP Functions
Top Questions
Ask a Question
PHP Interview Questions
PHP Jobs
Ecommerce
IT Questions
Business Websites

Sponsors

sponsor ad
My Salary
PHP Developer Salary
Advertise Here

PHP Questions Forums : mySQL Questions and Answers

Jump to Last Post

Update not working for larger text input

By: Jasonwood [23-February-10 7:55AM]
2 posts
picture

Hi-

I'm running MAMP on my Mac with MySQL 5.0.19 as my local test server. My live server is with Media Temple running MySQL - 5.0.22.

On the site I'm developing, I have a text field which I load text into, let the user modify it, and post it back to the database. Very basic.

Everything works great on my local server. When I upload it, everything works fine with 300-400 words of text. When I try to put in larger amounts of text into the field (3,000+ words), it acts like it's updating but doesn't. The text in the database remains the same as though no update was performed.

I'm not sure if this is a server issue, a PHP issue, or a MyQSL issue. Any ideas why it works locally but not remotely?

Thanks!

-Jason

Re : Update not working for larger text input


Jasonwood [23-February-10 9:21AM]
2 posts
picture

Ok, I figured out what was wrong. There was an invalid character in the text field – nothing to do with the text amount. Once I filtered it out before the update, everything ran smoothly.

Thanks

-Jason

Previous: Ordering Results In MySQL
Next: Help With Grouping Queries In MySQL



Custom Search