Displaying special character...

[elmas156]

I'm having a problem that I didn't seem to have in the past... for some reason, it just popped up... or maybe I'm just noticing it.  Anyway, I this in a field in a mysql database:

 

"Here's a test."

 

When I query the database and echo the text to the page with this code:

 

$result = mysql_query("SELECT question FROM signin WHERE email = '$email'") or die (mysql_error());
$row = mysql_fetch_row($result);

$test = $row[0];

echo $test;

 

This is the result:

 

"Heres a test."

 

Any ideas on why the apostrophe is not being displayed and how to fix it?  I'm stumped.  Thanks for any help.

 

 

[btherl]

What do you use to view the field in the database?

[elmas156]

phpMyAdmin is how I view the database and its contents.

[btherl]

Hmm, try this code instead of the plain echo:

 

echo urlencode($test);

[elmas156]

No luck... still no apostrophe too 

[btherl]

What does this show:

 

$result = mysql_query("SELECT * FROM signin WHERE email = '" . mysql_real_escape_string("Here's a test.") . "'") or die (mysql_error());
$row = mysql_fetch_row($result);

var_dump($row);

[elmas156]

I just found the problem!  I finally just broke down and rewrote the whole section of code and I realized that I was pulling info from the "signin" table when I should have been getting it from the "staff" table!  Basically, I was querying the wrong information.  Silly mistakes cost me so much time!  Thanks for your help.

[Zane]

Silly mistakes cost me so much time!  Thanks for your help.

That should be the new motto for this place.

[elmas156]

Haha... We all make them, some are just better at finding them than others.  The ones that I hate the most are the ones where there's not really any problem in the code, so you get no errors... just the wrong output, so you're left trying to trace your steps, usually to find that the only problem was yourself!  Funny how something works right when you do it right...