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 ... 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()); 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; 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 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. 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! Link to comment https://forums.phpfreaks.com/topic/242643-update-wont-run/#findComment-1246315 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.