Phpmyadmin not UPDATING fields after they've been edited within Phpmyadmin [closed]?

Up vote 0 down vote favorite share g+ share fb share tw.

I have a xampp local root set up (windows7) I have been updating my database no problem through my php code However if I edited some fields (eg putting values in to then test if sttatements etc) WITHIN phpmyadmin, whem I try to UPDATE this field through php it remains at value that I edited it to. (sorry if not clear, try it like this..) Difficult to have code for this but imagine Default Value = 0, After php code (+5), echoes 5, Database Value = 5 But if I edit within Phpmyadmin Default Value = 0, I edit to Value = 3, then, after php code(+5), echoes 8, Database Value = 3 (not 8) Refreshing it changes nothing Leaving the table and using the php code has no effect Is this a xampp problem? Does editing a field within Phpmyadmin change its nature?

Is it something I'm just blissfully ignorant of? One other curiosity. If I process the page twice it echoes 13 (it Quesries the database record!

) but database value remains 3. If However I refresh the database table browse page before resending the PHP it echoes 8, but database value remains 3 WORKAROUND - I closed my phpmyadmin firefox window, used the PHP code, then saw that the database value (which had been edited from the ddefault) was updated correctly. Any ideas?

Php mysql phpmyadmin xampp link|improve this question edited Nov 17 '11 at 21:25 asked Nov 17 '11 at 20:26Adam Narbutt876 89% accept rate.

1 My guess is you have a problem with your php code that is supposed to add 5 to that fields. Nothing to do with phpmyadmin, like you are saying in the post, you change it to 3 and it becomes 3, but after running your script it is still 3 instead of 8... What is the correlation with phpmyadmin in this case, it looks to me as your script is bugged, not phpmyadmin... – Mathieu Dumoulin Nov 17 '11 at 20:28 Can you give your code and sql schema? – Utku Y?

Ld? R? M Nov 17 '11 at 20:29 Show the queries you use in PHP, please.

– Juhana Nov 17 '11 at 20:30 mysql_query("UPDATE table SET $fieldVariable = ‘$newValue’ WHERE userID = '". $_SESSION'userID'. "' ")or die("Query failed:".

Mysql_error()); – Adam Narbutt Nov 17 '11 at 20:33 as I STRESSED in the question the code works – Adam Narbutt Nov 17 '11 at 20:34.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.