[SOLVED] Copy mySQL table data containing html

[PDM]

I'm having a problem copying data from fields that contain html code.

 

I'm getting the data from the table using php and can output it to the browser without problem.

 

 
          $thisPostDate = $row_GetBlogBase['PostDate'];
  $thisCategory = $row_GetBlogBase['Category'];
  $thisAuthorName = $row_GetBlogBase['AuthorName'];
  $thisAuthorEmail = $row_GetBlogBase['AuthorEmail'];
  $thisTitle = $row_GetBlogBase['Title'];
  $thisDesc = $row_GetBlogBase['Desc'];
  $thisKeywords = $row_GetBlogBase['Keywords'];
  $thisHeadline = $row_GetBlogBase['Headline'];
  $thisIntro = $row_GetBlogBase['Intro'];
  $thisNewsStory = $row_GetBlogBase['NewsStory'];
				  
$insertSQL = "INSERT INTO news_blog (PostDate, Category, AuthorName, AuthorEmail, Title, `Desc`, Keywords, Headline, Intro, NewsStory) VALUES ('$thisPostDate', '$thisCategory', '$thisAuthorName', '$thisAuthorEmail', '$thisTitle', '$thisDesc', '$thisKeywords', '$thisHeadline, '$thisIntro', '$thisNewsStory')";

  mysql_select_db($database_MyBLOGS, $MyBLOGS);
  $Result1 = mysql_query($insertSQL, $MyBLOGS) or die(mysql_error());

 

When $thisNewsStory contains html code

<img src="http://www.myweb.com/images/topleft.gif" align="right" vspace="5" hspace="5" border="1">

I get a mySQL syntal error like

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'src="http://www.myweb.com/images/topleft.gif" align="right" vspace="5" hspace="5' at line 1

 

???

[PDM]

Found missing '

 

'$thisHeadline