nicuz Posted October 16, 2007 Share Posted October 16, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/73529-error-in-your-sql-syntax/ Share on other sites More sharing options...
maxudaskin Posted October 16, 2007 Share Posted October 16, 2007 Make adTitle and adInfo longtext. Quote Link to comment https://forums.phpfreaks.com/topic/73529-error-in-your-sql-syntax/#findComment-370970 Share on other sites More sharing options...
BlueSkyIS Posted October 16, 2007 Share Posted October 16, 2007 the problem is the single quote in the value. you need to escape your values using mysql_real_escape_string(); Quote Link to comment https://forums.phpfreaks.com/topic/73529-error-in-your-sql-syntax/#findComment-370974 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.