[message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 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 'http://www.nutralegacy.com/blog/wp-content/uploads/2010/12/10-more-home-remedies' at line 1

[string:Exception:private] => 
[code:protected] => 42000

[file:protected] => /home/servers/xx.com/dev.xx.com/blog/dbh.php

[line:protected] => 61

$sql = INSERT INTO wp_comments ( comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id ) VALUES ('7740', 'Jonathan', '', '', '127.0.0.1', '2010-12-30 05:20:59', '2010-12-30 10:20:59', '<div style="float: right; padding: 0pt 0pt 0pt 10px;"><img src="http://www.nutralegacy.com/blog/wp-content/uploads/2010/12/10-more-home-remedies-for-acne-and-pimples_1.jpg" alt="Top 10 Unbelievable Remedies For Acne And Pimples" title="Top 10 Unbelievable Remedies For Acne And Pimples" border="0"></div>
In the last article we discussed 10 natural home remedies to cure <a href="http://www.xx.comhttp://www.xx.com/blog/tag/acne-breakouts/">acne breakouts</a>. Below you will find 10 more remedies for acne and pimples.  Instead of using harsh abrasive ointments and creams, try using these preventative measures and alternate natural solutions to better skin.&nbsp;<a href="http://www.xx.com/blog/general-healthcare/10-more-home-remedies-for-acne-and-pimples/">Read more</a>', '0', '1', '', '', '0', '475');

Please help any suggestions i am going crazy.

    $sql="        ";

    try to use qoute-marks around your PHP strings, then you have to escape the HTML double qoutes if you add into SQL string.

    Like in this example:

    $sql="  insert into table () VALUES ('html code <div id=\"\"></div>','Other stuff')";
      Write a Reply...