htmlspecialchars and so on..

[badHabitZ]

Hey guys,

Just a simple question maybe. I'm using a news system on my website which I've made myself, but the news does not enter into the database when using any special character like below:

~ or ` or ' or "

I've tried using the following but it still does not work:

PHP Code:

$news = htmlspecialchars(htmlentities(stripslashes(trim($_POST['news'])))); 


Anyone knows the right way to use this so I can still use the "special characters"? :P

Thanks in advance!

[MattF]

Assuming MySQL, mysql_real_escape_string().

[badHabitZ]

Thanks, that worked