putting php + html in a database

[Anon]

hey there.

i need to insert some html into a feild in a database. What i've been doing is placing the html inside a variable, and then inserting the variable into the database as shown below:

$var = "
<...html code...>
";

$result = mysql_query("INSERT INTO $table set data='$var'") or die (mysql_error());

The problem is that in order to use this method, each quote (") in the html must be escaped using a slash "\". Is there a way to get html into a database without having to escape the quotes?

Also, i need to add some php to the html -t that really dosen't work!

Can anyone help me out?

Thanks in advance!

[Anon]

I dont know if this helps at all..

But you could try converting all quotes to another character before entering it into the database, then convert it back when you use it. In some of the CGI scripts I wrote I'd want to store the information in a text file, but if the user entered a carriage return it'd write it into the text file and get the spacing all wrong. So instead, before I wrote it to the text file I converted all \n to another most likely unused ascii character like the copywrite symbol or whatever that you won't need to use. Then when you go to print it out again just convert the character back, ie convert all copywrite symbols in that line to quotes.