Updating Large Data in MySQL through front end

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
faisy_master
Forum Newbie
Posts: 10
Joined: Sun Aug 21, 2005 1:29 am

Updating Large Data in MySQL through front end

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

post the code you used (and the error you get) to update this field.
Post Reply