|
Posted by Shawn Wilson on 09/17/05 01:06
I have a photo album page written in PHP where I pull captions and such from
an SQL
database and the result is of course an HTML page.
My problem is with the use of an apostrophe (single quote) and other such
characters as they break my HTML. I'm also using javascript and it's a
problem there as well.
How should I store such characters in SQL, or maybe just how should I read
them out so they can't break my code, yet they show up on the screen fine?
The method I use to insert such characters works without problems. In the
SQL I get what was intended... e.g. Ginny's Wedding
However when I pull it out I get this: (seemingly correct)
<a href="album.php?albumid=293&frompage=1"><img id="img_two"
src="data/293/0/cover3.jpg" alt="Ginny's Wedding"
onMouseOver="switchit('Ginny's Wedding - Jun 11 2005');"
onMouseOut="clearit();"></a><br>
....But then my JS broken because the text is in single quotes and another
extra one breaks it.
--
Shawn Wilson
[Back to original message]
|