Jump to content


' and " errors

  • Please log in to reply
2 replies to this topic

#1 anonnerz

  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 07 July 2006 - 12:24 AM

I've been making a script recently whic requires me to include variables/data/information (w/e) from a SQL database. I have got to a point where I have information put into double quotes, an example of which is:

OnMouseDown='set("{$this->sql_fetch[desc]}", "image_resize.php?src=uploads/{$this->sql_fetch[File]}", "{$this->sql_fetch[id]}", "uploads/{$this->sql_fetch[File]}");

However one of the variables I am calling already has an apostrophe in it, such as(quote from temp. database):

This description holds an apostrophe (' <-- look it's there... and again) to see what it does to my code

... I am wondering if there is any way to get around this. I am aware of the \' trick used when echoing, can this be used in some way?

Thanks everyone.

Oh and BTW the part where the problem is (the above code) is in an EOF echo/variable assignment... If that helps you think of something at all... therefore come to think of it it's an issue with the inclusion of the same marks in javascript...

#2 micah1701

  • Members
  • PipPipPip
  • Advanced Member
  • 613 posts
  • LocationEllington, CT USA

Posted 07 July 2006 - 12:51 AM

if the variable is in PHP, then you can use addslashes() to escape the 'single quote mark'

check out http://us3.php.net/addslashes
"Confidence in the face of risk."

#3 anonnerz

  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 07 July 2006 - 02:35 AM

Ok worked it out, thanks =D

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users