How do I keep from getting exceptions with special characters while inserting into the database

I get this error

SQL/DB Error -- [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 's the message for the friend. Besides the exclamation point every character seem' at line 2]

$(function(){ $("#accordion").accordion({ header: "h3" }); $('#tabs').tabs(); $('#dialog').dialog({ autoOpen: false, height: 480, width: 600, buttons: { "Ok": function() { $(this).dialog("close"); }, "Cancel": function() { $(this).dialog("close"); } } }); $('#dialog_link').click(function(){ $('#dialog').dialog('open'); return false; }); $('#dialog_link, ul#icons li').hover( function() { $(this).addClass('ui-state-hover'); }, function() { $(this).removeClass('ui-state-hover'); } ); }); $(document).ready(function() { // Tell jQuery that our div is to be a dialog $('#contactbus').dialog({ autoOpen: false, height: 300, width: 277 }); $('#bttn1').click(function() { $('#contactbus').dialog('open'); }); }); $(document).ready(function() { // Tell jQuery that our div is to be a dialog $('#tellafriend').dialog({ autoOpen: false, height: 340, width: 277 }); $('#bttn2').click(function() { $('#tellafriend').dialog('open'); }); }); When i'm trying to use a ! or ' from a textarea.

I'm sure there is an easy solution using php i'm just not sure where to start. Thanks for any help anyone can give me.

Great content, let me share it! »