Jump to content

Error in your SQL syntax


nicuz

Recommended Posts

I've made a classified ads website. I have 2 fields in my database:

adTitle which is varchar 255

adInfo which is varchar 255

 

Whenever I try to post an ad that contains the character ' in the title I get an error.

 

So for example if the title of my ad is: 12' pencil

I get the following 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 'pencil','nick','32','accessories','2007-10-16','Deonne','2007-12-15

 

I don't understand because the 2 fields are both varchar 255 but if I use the ' symbol in the adInfo fields, I get no error. Only in adTitle.

 

Anyone knows what's wrong?

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/73529-error-in-your-sql-syntax/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.