Hi all,

trying to pull some data from my MySQL database, including a small paragraph of text that uses a few hyphens... Of course, when printing this I am left with strange characters where the hyphen should be. I've tried coding the addslashes function into my script, but that just produced a parser error...

My script is as follows:

PHP Code:

<?php 
// Collects data from "friends" table 
$data = mysql_query("SELECT * FROM bio") 
or die(mysql_error());

while($info = mysql_fetch_array( $data )) 
{ 
Print "<div class='bio-image'><img src='images/bio/rotate.php'></div><a class='bio-text'>".$info['text']."</a>";
}
?>

I've tried the following to no avail:

PHP Code:

<?php 
// Collects data from "friends" table 
$data = mysql_query("SELECT * FROM bio") 
or die(mysql_error());

while($info = mysql_fetch_array( $data )) 
{ 
Print "<div class='bio-image'><img src='images/bio/rotate.php'></div><a class='bio-text'>"addslashes(.$info['text'].)"</a>";
}
?>

And I've also tried:

PHP Code:

<?php 
// Collects data from "friends" table 
$data = mysql_query("SELECT * FROM bio") 
or die(mysql_error());

while($info = mysql_fetch_array( $data )) 
{ 
Print addslashes("<div class='bio-image'><img src='images/bio/rotate.php'></div><a class='bio-text'>".$info['text']."</a>");
}
?>

But again, this didn't work...

The page in question is here if you would like to see it in action...

Any help would be greatly appreciated!!!

This is typical of a copy/paste between applications with different charset, or from word.

This character represent a "symbol" that the font have no representation for. I know that word replace hypens with those, as it does with the "..." and some others characters.

Nothing much to do here except a search/replace or re-write those hyphens with the correct ascii characters.

I use a modified version of the code at http://shiflett.org/blog/2005/oct/co...uotes-with-php to handle crappy stuff entered by client's who don't understand that a smart quote is not smart at all. That may help you by converting them into HTML entities.