470,833 Members | 1,382 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,833 developers. It's quick & easy.

Problem with Mysql Query

JB
Hello,

I'm experiencing a very strange problem with a MySQL query.

Firstly, I use mysql_query() to print the value that I need to modify
I modify it by doing an update ( mysql_query("UPDATE TABLE ...") ) .
When I look into the table directly (with phpmyadmin) the value has
been correctly changed.

But when I use again mysql_query() to print the new value,
it gives me the last value that were there, before the update.
I have to refresh the page ( F5 ) to get the correct result.

I have this problem only with IExplorer.
It works with Mozilla.

Somebody told me that maybe it was a problem of the cache of my
Explorer, but I didn't manage to find anything to make it work.

Does anybody know what's happening?

Thanks

Jean Baptiste Isnardon
Jul 17 '05 #1
3 2415
On 2004-01-13, JB <je*******************@yahoo.fr> wrote:
Hello,

I'm experiencing a very strange problem with a MySQL query.

Firstly, I use mysql_query() to print the value that I need to modify
I modify it by doing an update ( mysql_query("UPDATE TABLE ...") ) .
When I look into the table directly (with phpmyadmin) the value has
been correctly changed.

But when I use again mysql_query() to print the new value,
it gives me the last value that were there, before the update.
I have to refresh the page ( F5 ) to get the correct result.

I have this problem only with IExplorer.
It works with Mozilla.

Somebody told me that maybe it was a problem of the cache of my
Explorer, but I didn't manage to find anything to make it work.

Does anybody know what's happening?


As it works in Mozilla, it's obviously not a scripting problem,
posting your problem in a windows group seems more appropriate.

(And yes, that somebody was right about IE and incorrect caching
methods...)

--
http://home.mysth.be/~timvw
Jul 17 '05 #2
session_cache_limiter('private, must-revalidate');

stick this line at the top of your php file. It will make the page in
question refresh for sure instead of trying to use a cached page.

Works for me!

Chris

"JB" <je*******************@yahoo.fr> wrote in message
news:47**************************@posting.google.c om...
Hello,

I'm experiencing a very strange problem with a MySQL query.

Firstly, I use mysql_query() to print the value that I need to modify
I modify it by doing an update ( mysql_query("UPDATE TABLE ...") ) .
When I look into the table directly (with phpmyadmin) the value has
been correctly changed.

But when I use again mysql_query() to print the new value,
it gives me the last value that were there, before the update.
I have to refresh the page ( F5 ) to get the correct result.

I have this problem only with IExplorer.
It works with Mozilla.

Somebody told me that maybe it was a problem of the cache of my
Explorer, but I didn't manage to find anything to make it work.

Does anybody know what's happening?

Thanks

Jean Baptiste Isnardon

Jul 17 '05 #3
JB
Thank you very much!

Actually I use session_cache_limiter('nocache'); to make it work under IExplorer.


"Christopher Johnson" <ch*****************@augustana.edu> wrote in message news:<09XMb.45331$I06.281343@attbi_s01>...
session_cache_limiter('private, must-revalidate');

stick this line at the top of your php file. It will make the page in
question refresh for sure instead of trying to use a cached page.

Works for me!

Chris

"JB" <je*******************@yahoo.fr> wrote in message
news:47**************************@posting.google.c om...
Hello,

I'm experiencing a very strange problem with a MySQL query.

Firstly, I use mysql_query() to print the value that I need to modify
I modify it by doing an update ( mysql_query("UPDATE TABLE ...") ) .
When I look into the table directly (with phpmyadmin) the value has
been correctly changed.

But when I use again mysql_query() to print the new value,
it gives me the last value that were there, before the update.
I have to refresh the page ( F5 ) to get the correct result.

I have this problem only with IExplorer.
It works with Mozilla.

Somebody told me that maybe it was a problem of the cache of my
Explorer, but I didn't manage to find anything to make it work.

Does anybody know what's happening?

Thanks

Jean Baptiste Isnardon

Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by thomas-lists | last post: by
1 post views Thread by Lynton Towler | last post: by
1 post views Thread by James | last post: by
reply views Thread by Daniel Crespo | last post: by
3 posts views Thread by auron | last post: by
3 posts views Thread by Juan Antonio Villa | last post: by
9 posts views Thread by George Webb | last post: by
30 posts views Thread by Einstein30000 | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.