Pulling html from mysql

[amars1983]

I'm using tinymce to build a blog for a personal site. I have everything working correctly as far as getting everything into the mysql db, but when pulling all the code from it, it seems to not see it as html code. I inserted just regular text into a field just to make sure my call to the database was working correctly, which it was, but it won't seem to work with the html. Any thoughts?

[Old Pedant]

Use MySQL tools--not any web based tools--to view the data and see if your HTML is there. I will be it it and the problem is in the code that reads the records. But check it out.

[amars1983]

I was able to look in the database and the html was there.

[amars1983]

What is a good tool that isn't web based. I've been using phpMyAdmin. Here's my code for reading the records:

<?php
$con = mysql_connect("xxx","xxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("xxx", $con);

$blogentry = sprintf("SELECT 'Time', 'Content'
FROM Blog
ORDER BY 'Time' DESC");
$exeentry = mysql_query($blogentry, $con) or die(mysql_error());
$rowentry = mysql_fetch_assoc($exeentry);
$totalentry = mysql_num_rows($exeentry);?>


<?php if ($totalentry > 0) {do { ?>
<br /><p>
<?php echo $rowentry['Content']; ?><br />
<?php echo $rowentry['Time']; ?> </p>
<?php } while ($rowentry = mysql_fetch_assoc($exeentry));
}?>
<?php mysql_close($con)
?>

[guelphdad]

Your problem is your php code. You do the call to: mysql_fetch_assoc but then don't print anything out after that, you have your echo statements prior to fetching the data.

[Old Pedant]

Originally Posted by guelphdad

Your problem is your php code. You do the call to: mysql_fetch_assoc but then don't print anything out after that, you have your echo statements prior to fetching the data.

Ummm...huh???

...
$rowentry = mysql_fetch_assoc($exeentry);
$totalentry = mysql_num_rows($exeentry);?>


<?php if ($totalentry > 0) {do { ?>
<br /><p>
<?php echo $rowentry['Content']; ?><br />
<?php echo $rowentry['Time']; ?> </p>
<?php } while ($rowentry = mysql_fetch_assoc($exeentry));
}?>

Granted, that seems a bit clumsy way to write the code, but it sure looks to me like fetch_assoc is called before each display of the data.

[guelphdad]

Originally Posted by Old Pedant

Granted, that seems a bit clumsy way to write the code, but it sure looks to me like fetch_assoc is called before each display of the data.

Agreed, I missed it being a DO WHILE and not just a WHILE with the DO not broken out to it's own line. But yeah very sloppy if you ask me.

[oesxyl]

Originally Posted by amars1983

I was able to look in the database and the html was there.

try:
http://www.php.net/manual/en/functio...ecialchars.php
http://www.php.net/manual/en/functio...ars-decode.php

best regards