Updating Large Data in MySQL through front end

[faisy_master]

Hi,
I'm using a field in my database of MySQL of type "long text", in which I'm storing all the page HTML. Here is an example:-

<H2 align="center">Collectorates</H2>
<table><tr><td ><img src="../../media/images/body/misc/spacer.gif" alt="" border="0" height="9" width="2"></td></tr></table>
					<TABLE width="96%" class="linear" cellSpacing="0" cellPadding="3" border="2" style="BORDER-BOTTOM-STYLE: double; BORDER-TOP-STYLE: double; BORDER-LEFT-STYLE: double; BORDER-RIGHT-STYLE: double;">
                      <tr valign="top" bgcolor="#CECABD" bordercolor="#CECABD">
                        <td width="43" valign="top"><p align="center">Serial No. </p></td>
                        <td width="425" valign="top"><p align="center">Area </p></td>
                        <td width="122" valign="top"><p align="center">Collectorate of Federal Excise </p></td>
                      </tr>
                      <tr>
                        <td width="43" valign="top"><p>1 </p></td>
                        <td width="425" valign="top"><p>Sindh excluding Karachi Division </p></td> ... ... ...

I'm using PHPMyAdmin to insert my data into MySQL.
Actually this is a whole page of a particular section, and it is available in the database because I want admin to even change the text through his Administrator Login.

Now here is the point where the problem arises. When I open this text into a <textarea> and then execute the update query for the Updation with this wholw HTML text, it gives me error.

Actually the spaces or quote marks does not let me save this data into the database.

There must be some function through which I can attain this thing... Beacuse when I did the same in PHPMySQL, it lets me save the changes and PHPMySQL is also made in PHP...

Thanks for your time.

[bbreslauer]

You can use the addslashes function (http://us3.php.net/manual/en/function.addslashes.php) to make the quotes OK for MySQL (I'm not sure about the spaces). You'll need to stripslashes() when you take it out of the database, though.

You should also make sure you're POSTing the form to PHP, and not GETing the form (i.e. in your form tag, method=post, not method=get).

[faisy_master]

Thanks buddy, I'll try it out ...

sounds valuable and effective.