anonnerz Posted July 7, 2006 Share Posted July 7, 2006 Hey, 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:[code]OnMouseDown='set("{$this->sql_fetch[desc]}", "image_resize.php?src=uploads/{$this->sql_fetch[File]}", "{$this->sql_fetch[id]}", "uploads/{$this->sql_fetch[File]}");[/code]However one of the variables I am calling already has an apostrophe in it, such as(quote from temp. database):[quote]This description holds an apostrophe (' <-- look it's there... and again) to see what it does to my code[/quote]... 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... Quote Link to comment https://forums.phpfreaks.com/topic/13910-and-errors/ Share on other sites More sharing options...
micah1701 Posted July 7, 2006 Share Posted July 7, 2006 if the variable is in PHP, then you can use addslashes() to escape the 'single quote mark'check out http://us3.php.net/addslashes Quote Link to comment https://forums.phpfreaks.com/topic/13910-and-errors/#findComment-54178 Share on other sites More sharing options...
anonnerz Posted July 7, 2006 Author Share Posted July 7, 2006 Ok worked it out, thanks =D Quote Link to comment https://forums.phpfreaks.com/topic/13910-and-errors/#findComment-54205 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.