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 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. 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(); 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
Archived
This topic is now archived and is closed to further replies.