Inserting HTML

[raouleduke]

I am trying to update a field in a database, with something from another table, the value of the data is in HTML for. Like this.

<table width='436' height='139' border='0' cellspacing='0' cellpadding='0' class='tableBorder'>
<style>
.tableBorder {
 border-top: 1px dashed #000000;
 border-bottom: 1px dashed #000000;  etc....

Here is my query:

$query = "SELECT template_coupon_layout FROM template_coupons WHERE template_coupon_id= '$templatecouponid' ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)){
$templatecouponlayout = $row["template_coupon_layout"];
}
$query1 = "UPDATE recommend SET $couponplacement='".$templatecouponlayout."' WHERE catagory='$catagory$subcatagory'";
print $query1."<br />"; 
$result1 = mysql_query($query1) or die(mysql_error());

I want to know how to make it insert it without paying attention to the html tags and ' s.
Thanks in advance.

[laserlight]

You dont need to worry about it during storage, assuming magic_quotes_gpc is set to escape the incoming variable automatically.

You will, however, have to use stripslashes() later on.
If you dont intend to have the HTML parsed, then use htmlspecialchars(stripslashes()) instead.

[raouleduke]

I got it figured out, I think I have been sitting in front of the computer for too long, I should have seen it.
here is the fix if anyone needs it.

$couponlayout = addslashes($templatecouponlayout);

Thanks,