PHP Learner Posted November 26, 2012 Share Posted November 26, 2012 [to the moderators, sorry, i dont know which section this actually belongs in] hi there all, im rewriting/updating/improving a site i wrote last year. i havent touched it since and it seem php has moved forward a few stages which is why i need to update bits around the site. anywayz, so im adding stuff to a query to update the table, i change it in the code, ftp the page sucessfuly etc.. but the new query is ignored by the MySql database or the newer PHP engine. i think its to protect against sql injection but im not sure. it makes sense and its a valuable security feature if that is it but is making testing impossible. would appreciate your help if you know how to get round it, or if i right even. thanks, phpl Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted November 26, 2012 Share Posted November 26, 2012 it's unlikely that anything from an update would cause the code to just not work. there would be an error/notice/warning about it on the page at the verry least. Let's see the code and we'll be better able to find the problem. Quote Link to comment Share on other sites More sharing options...
PHP Learner Posted November 26, 2012 Author Share Posted November 26, 2012 hello there, thanks very much for the response. silly thing is its not the code which is the problem. it worked fine with the original code, all i added was 1 extra update in the query same as the others to corrispond with a new row i put into the table. thing is, if it were a mistake, like somehow i put the wrong value or missed a comma or something i could debug it. thing is, i changed one of the values which is represented by a variable with a string which is meant for a varchar entry and there was no difference. it seems like its being ignored by the engine as an attempt to inject incorrect values into the data base. i know the pages are ftp'ing ok because i echoed a string at the top of the page to confirm the change in the code. hmmm, very confusing stuff any ideas? Quote Link to comment Share on other sites More sharing options...
PHP Learner Posted November 26, 2012 Author Share Posted November 26, 2012 sorry, yes, and im watching for the changes in phpmyadmin and the entries are made but without the changes i have made in the mysql_query. hmmm... scratchy heady Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted November 26, 2012 Share Posted November 26, 2012 well without actualy getting a look at what you are doing - nothing I can do, sorry. 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.