<script language=\"javascript\"> Display problem with PHP & MYSQL

[dr_dumb99]

Hi !
When I want to display following code by assigning it to $res["description"] , in the following mentioned way, it works fine and displays properly. The code is :
/************START CODE*****************/
<script language=\"javascript\">
var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11);
document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>');
</script>
/***********END CODE******************/

<tr>
<td colspan="4"><div align="center">
<?php
$res["description"] = "<script language=\"javascript\">
var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11);
document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>');
</script>";

echo $res["description"];

?>
</div></td>
</tr>

But when I get the value of $res["description"] from database , then nothing displays. I am using PHP and MYSQL and I have also confirmed that there is an entry in database with same code.

Thanks in advance

[Lafinboy]

Have a look at the source that is generated by the above code. You will no doubt see that there are errors in the generated source caused by escaped/unescaped characters from the database.

[Mr Violent]

Some characters do not get saved to a MySQL database, due to the way MySQL handles information. If your string you're inputting into a text or varchar field includes one of these symbols, ' for example, none of your information will be placed into the database.

You can solve this by using the html_special_chars() function to convert your code into HTML characters that are safe for storage.