' != ? HTML problems...
I have created a page that is database driven so the end users can manage the content on their own. All of the source code for the page shows ' where they should be, but the page shows ? in most places that ' should be.
http://www.urbanlovedating.com
How can I resolve this?
Thanks.
artsapimp posted this at 16:38 — 13th June 2005.
They have: 330 posts
Joined: Apr 2000
Sorry - see the About Us page to see what I'm talking about.
Greg K posted this at 16:46 — 13th June 2005.
He has: 2,145 posts
Joined: Nov 2003
Hi, this was recently discussed on this thread:
http://www.webmaster-forums.net/showthread.php?t=29126
It appears to be the "Content-Type" value.
-Greg
timjpriebe posted this at 16:51 — 13th June 2005.
He has: 2,667 posts
Joined: Dec 2004
Have you checked how it's actually stored in the database? I would go there and make sure it's just a single quote. I'm not sure from your post if you actually did that. It could be an angled quote, or it may have ended up some weird symbol in the actual database.
Also, and forgive me if you're aware of this, before any strings with single quotes can be used in a SQL statement, you have to make them two single quotes (''). That's different from one double quote ("). SQL will see two single quotes and know you meant one single quote.
PHP, PERL and other languages make it very easy to just replace all the ' with '' right before you use it in the SQL statment.
Tim
http://www.tandswebdesign.com
artsapimp posted this at 17:18 — 13th June 2005.
They have: 330 posts
Joined: Apr 2000
Thank you both for your help. The encoding type was the problem.
Greg K - What made you choose weeklyraves.com in your example? That is also one of my sites and I gave up on fixing it because of that problem. I guess I have more work to do.
Thanks again to everyone for your help.
Free Math Test
Fun Math Games
Greg K posted this at 17:36 — 13th June 2005.
He has: 2,145 posts
Joined: Nov 2003
I used that as an example becasue I had just recently been to the site and recognized the <?> symols on there. Don't give up on that site, I bookmarked the odd's calculator
artsapimp posted this at 15:13 — 14th June 2005.
They have: 330 posts
Joined: Apr 2000
Thanks for the motivation. I will try to find time in the near future to re-tackle that project.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.