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

[Tim Van Wassenhove]

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

[Christopher Johnson]

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

[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