Pulling Text From MySQL and using its Tags

rayishu

hello i think this might be a noobish question but i got this text in a colum that has some some HTML tags on it but when i load the text into my page the code doesnt execute, actually it doesnt even show up at all it just gets masked

is there a PHP function or trick that will take this mysql text with html tags and actually use those tags thank you.

etully

Unless I'm misunderstanding you, it sounds like the "print" or "echo" command are all you need. For example:

<?php
// open the database connection
mysql_connect("localhost","myusername","mypassword");
@mysql_select_db("mydatabasename") or die( "Unable to select database");

// read the data into a variable
$query = "select display_text from my_table";
$result = MYSQL_QUERY($query);
$display_text=mysql_result($result,0,"display_text");

// Make the HTML appear
print "$display_text";
?>

rayishu

when i print out the text the HTML Tags in the Tables text dont show up and execute

etully

It's probably making bad HTML. Can we see an example of the resulting HTML or point us to a link?

rayishu

actually its not just HTML its Javascript <script language="JavaScript" src="http://digg.com/diggjs/user/homepage//16" type="text/javascript"></script>

etully

So let me see if I understand correctly. You have a PHP page that builds HTML that includes Javascript. And the HTML with the Javascript is not showing anything up. Is the Javascript supposed to write HTML with the writeln command? Is the HTML supposed to trigger the Javascript?

The Javascript that you pointed to ( http://digg.com/diggjs/user/homepage//16 ) doesn't seem to exist... that would be at least one of the problems. Another problem is likely that the HTML is broken but I can't tell since I can't see it. Can we see an example of the HTML that is produced by the PHP?

rayishu

the text from the database has the script and is supposed to load into the PHP file and then that texts HTML sould be executed