str_replace apostrophes

[$var]

this is what i've got: str_replace("&#39","'",'<br />',$_POST["solution"])
i need it to allow "'" and replace line breaks with "<br />"

thank you!

[NogDog]

$search = array('&#39;', '<br />');
$replace = array("'", "\n");
$newString = str_replace($search, $replace, $oldString); 

[bokeh]

$search = array('&#39;', '<br />');
$replace = array("'", "\n");
$newString = str_replace($search, $replace, $oldString); 

Something strange happened with the quotes.

[The Little Guy]

$search = array(''', '<br />');
$replace = array("'", "\n");
$newString = str_replace($search, $replace, $oldString); 

don't you need to escapestring?

Like this:

$search = array('\'', '<br />');
$replace = array("'", "\n");
$newString = str_replace($search, $replace, $oldString); 

[bokeh]

don't you need to escapestring?

It's how the forum parsed the post.

[NogDog]

Thanks, fixed it by using the numeric character entity for "&" followed by "#39;".

[$var]

argh... it doesn't appear to be working... or at least, when i the entry is updated into the database, it throws this error (where "test as's" is what i entered to see if it was working):

test as'sYou 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', '2006-11-16 01:11:44')' at line 13test as'sYou 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', '2006-11-16 01:11:44')' at line 13

[NogDog]

You'll need to escape any quotes before using the value in a query. If using mysql, use the mysql_real_escape_string() function, otherwise use addslashes().