artsapimp — Tue, 14 Jun 2005 15:13:47 +0000

Thanks for the motivation. I will try to find time in the near future to re-tackle that project.

Greg K — Mon, 13 Jun 2005 17:36:36 +0000

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 — Mon, 13 Jun 2005 17:18:11 +0000

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.

timjpriebe — Mon, 13 Jun 2005 16:51:49 +0000

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.

Greg K — Mon, 13 Jun 2005 16:46:54 +0000

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

artsapimp — Mon, 13 Jun 2005 16:38:24 +0000

Sorry - see the About Us page to see what I'm talking about.