Insert Problem

[neroag]

Hi
I have a problem when fetching data into a string from a database like ...

<h1>BUY CHEAP PINE WITH FREE DELIVERY</h1>
<br> <a href="#" id="example-show" class="showLink" onclick="showHide('example');return false;">
See more on Pine at my site</a>

when i try to INSERT it back into the database it errors i assume with the html, quotes etc in the resulting string

is there a way i can preserve the html etc in the string & insert it back into a database ?

[bradgrafelman]

How are you trying to insert it into the DB? Sounds like you aren't properly escaping the data (or escaping the data at all, for that matter).

[neroag]

Hi Brad

Im not using any escaping at all you right, Im not sure how to do it thats the issue im having

thanks

[Bonesnap]

Enclose your input in mysql_real_escape_string().

[bradgrafelman]

Or [man]mysqli_real_escape_string/man if you've (hopefully) ditched the older [man]mysql[/man] library of functions for the newer [man]MySQLi[/man] extension instead. Or... whatever equivalent escaping mechanism is provided by the SQL extension you're using.