updating data with a mysql db

[trantron]

<Text Area> updating data with a mysql db

I have Text and MediumText data types in the table in th Mysql db and am using Text Areas to collect data from the user and to update it later.

I notice that when there is a lot of text data and I want to do an “update” from my update page, sometimes it won’t let me pass the data to the php page that does the work of UPDATING the database.

On the original INSERT the data was accepted no problem, I only have this problem on the UPDATE part.

I can; however, manually go into Mysql and put the data in there.

If you have any knowledge that you can pass on to explain this anomaly I would be greatly appreciative.

[AstroTeg]

First question: what browser are you using?

Second question: is the form method set to "get"?

[trantron]

I am using GET for the method and my browser is IE V. 6

[trantron]

I took a cue from AstoTeg and used the post method instead of get.

Using post solved the problem.

Thanks AstroTeg !

[AstroTeg]

I didn't get a chance to reply in time, but yes, you found you're sending too much data for IE and IE chokes on the URL. For a quick fix, you could do it with Firefox to prove it was a problem with IE. Put yes, the quick fix is to switch to POST. (I just had this problem last week.)