php - Storing formatted text from tinymce in database -

i have tinymce textarea put in default text page loaded. text formatted bold faced , underlined. of works well. however, when go store text in mysql database, following error:

error adding email database: have error in sql syntax; check manual corresponds mysql server version right syntax use near ... @ line 5

here how creating default text inside of textarea;

window.onload = function formattext() {     tinymce.get("results").setcontent("<b><u>results</b></u><br><br><br>");     tinymce.get("upcoming_races").setcontent("<b><u>upcoming events</b></u><br><br><br>");     tinymce.get("thisweek").setcontent("<b><u>this week's training</b></u><br><br><br>");  } 

when take code out , type text in manually (along formatting text using tinymce buttons), saves in database perfectly. don't know how text both appear formatting , able save via php/mysql call.

does know how this? thanks!

edit: here relevant php code. note (as mentioned) code works fine if manually type , format text. however, fails when use javascript set text me.

$sql = "insert emails             (date, subject, greeting, results, upcoming, thisweek, signoff)             values              ('$today', '$subject', '$greeting', '$results', '$upcoming',              '$thisweek', '$signoff')";  $result = mysql_query($sql); 

edit 2: here echo of $sql text. strange me of carriage returns, must come javascript:

insert emails (date, subject, greeting, results, upcoming, thisweek, signoff) values ('2013-07-23', 'test', ' test ', ' results

', ' upcoming events

', ' week's training

', ' test signoff ')

i use below function need convert mysql mysqli ... need anyhow or code not work upcoming releases. link http://php.net/manual/en/mysqli.query.php

also note code modified have in classes might little off ... don't use global etc etc.

function escapestring($string) {      global $connection;      // depreciated function     if (version_compare(phpversion(),"4.3.0", "<")){         return mysqli_escape_string($connection, $string);     } else {         return mysqli_real_escape_string($connection, $string);     }  }   $sql = "insert emails             (date, subject, greeting, results, upcoming, thisweek, signoff)             values              ('" . escapestring($today) . "', '" . escapestring($subject. "', '" . escapestring($greeting) . "', '" . escapestring($results) . "', '" . escapestring($upcoming) . "',              '" . escapestring($thisweek) . "', '" . escapestring($signoff) . "')";