Jump to content


Photo

mysql error, please help


  • Please log in to reply
2 replies to this topic

#1 darkcarnival

darkcarnival
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts

Posted 13 July 2006 - 08:56 PM

hello,

im trying to make a convertor to phpbb. and so far the only problem has been with the topic & post area.

now wheever i try to add a topic or post that has ' in it i get this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 're banning bbcode on this post! cant see this bold


now i tried to add stripslashes() to the body variable but that didnt work. any ideas? should i try addslashes()?

thanks.

#2 ShogunWarrior

ShogunWarrior
  • Members
  • PipPipPip
  • Advanced Member
  • 528 posts
  • LocationIreland

Posted 13 July 2006 - 09:07 PM

Yeah, run addslashes to it or mysql_escape_string
<a href="http://www.daviddora...nmedia.com/">My New Site/Blog</a> | <a href="http://www.daviddora...m/check/">Check your page for broken links/images/scripts</a>

Zend Certified Engineer
Follow me on Twitter: http://twitter.com/davidd

#3 darkcarnival

darkcarnival
  • Members
  • PipPipPip
  • Advanced Member
  • 162 posts

Posted 13 July 2006 - 11:43 PM

ok then thanks :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users