472,981 Members | 1,427 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,981 software developers and data experts.

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 2481
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: thomas-lists | last post by:
Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know...
4
by: Amadeus | last post by:
Hello Everybody! I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20) on Intel and MySQL server 4.0.14 (problem also appears on binary distr 4.0.15 and on 4.0.15 I bilt myself...
1
by: Lynton Towler | last post by:
Hello and thanks for reading this message. I have a Virtual Learning Environment (VLE) called "moodle 1.5.2" running on a server with 1Gb of RAM and MySQL version 4.1.13-1 which has been...
1
by: James | last post by:
Hey everyone, I have a really obscure but impassable problem with a reasonably simple piece of php/PEAR DB/MySQL code When calling several stored procs the first call succeeds, but subsequent...
0
by: Daniel Crespo | last post by:
Hi to all, I'm using adodb for accessing mysql and postgres. My problem relies on the mysql access. Sometimes, when I try to execute a query (using ExecTrans method below), I get this error:...
3
by: auron | last post by:
Hi there, I have a really stupid and banal problem with showing the results of a MySQL query in PHP, preciselly with MySQL count() function that gives to a variable in PHP the result. NOTE:...
3
by: Juan Antonio Villa | last post by:
Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to the slave, an example update reads as follows:...
8
by: Daz | last post by:
Hi everyone. I was faced with the choice of whether my problem is indeed a PHP problem or a MySQL. I have decided it's a PHP problem as I don't experience the same problem when I execute the...
9
by: George Webb | last post by:
Am just starting to learn PHP so I really don't know my way around but my first script works fine except for one problem. Within the script is a sql query that selects * from mytable. The result...
30
by: Einstein30000 | last post by:
Hi, in one of my php-scripts is the following query (with an already open db-connection): $q = "INSERT INTO main (name, img, descr, from, size, format, cat, host, link, date) VALUES ('$name',...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.