Page 1 of 1

Updating Large Data in MySQL through front end

Posted: Sun Aug 21, 2005 1:36 am
by 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:-

Code: Select all

<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.

Posted: Sun Aug 21, 2005 4:47 am
by feyd
post the code you used (and the error you get) to update this field.