manix Posted July 22, 2011 Share Posted July 22, 2011 I have this update syntax that doesn't wanna run and I'm getting pretty mad over it... the field "wall" is of type LONGTEXT if it makes any difference mysql_query("INSERT INTO users (`username`) VALUES ('dgd')"); // I added this line to check if the problem was with the db connection or something and it runs just fine, inserts the data and all .. mysql_query("UPDATE `users` SET `wall`= '$wall' WHERE `username`='Manix'"); // This is the mf troubling me >.< echo "<blockquote>$wall</blockquote>"; // this is where I echo the result from the ajax request which is also working perfectly fine ... Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/ Share on other sites More sharing options...
Maq Posted July 22, 2011 Share Posted July 22, 2011 Check for errors: mysql_query("UPDATE `users` SET `wall`= '$wall' WHERE `username`='Manix'") or die(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246226 Share on other sites More sharing options...
manix Posted July 22, 2011 Author Share Posted July 22, 2011 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 'viewprofile.php?user=Manix'>Manix: TEST ' WHERE `username`='Manix'' at line 1 still can't find it >.< I guess it's something wrong with this tho: $wall = "<p><a href='viewprofile.php?user=$username'>$username</a>: $comment</p>".$wall; Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246237 Share on other sites More sharing options...
manix Posted July 22, 2011 Author Share Posted July 22, 2011 wow the error was that I am using single quotes in the anchor tag.. but even if a user uses single quotes in his comment this is still going to return the error.. how do I allow single quotes in the record O.o Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246242 Share on other sites More sharing options...
fenway Posted July 22, 2011 Share Posted July 22, 2011 mysql_escape_string() is your friend. Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246248 Share on other sites More sharing options...
manix Posted July 22, 2011 Author Share Posted July 22, 2011 Indeed is. Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246315 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.