Orionsbelter Posted May 21, 2008 Share Posted May 21, 2008 Hello i've just bought a sever for my website as it was going slow on the hosting account, btu the thing is i don't no anything there is to know about a sever i thought it would be pretty much the same as a hosting account but its not:( and now some things on my website don't work like on my forum you can't input the ' sign into the database how can i fix this. many thanks blmg911 Quote Link to comment Share on other sites More sharing options...
Orionsbelter Posted May 21, 2008 Author Share Posted May 21, 2008 this is what i get: 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 'main', '0', '0', '1211349398','2008-05-21 05:53:38')' at line 1 Quote Link to comment Share on other sites More sharing options...
blueman378 Posted May 21, 2008 Share Posted May 21, 2008 could you not html encode the ' ? Quote Link to comment Share on other sites More sharing options...
bilis_money Posted May 21, 2008 Share Posted May 21, 2008 try this. "('1211349398','2008-05-21 05:53:38')" or could you post the complete codes here please. Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted May 21, 2008 Share Posted May 21, 2008 Indeed. Posting some code would be useful. Though it sounds like you could do with escaping your data with mysql_real_escape_string Quote Link to comment 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.