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 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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:...
|
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:...
|
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:...
|
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...
|
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...
|
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',...
|
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=()=>{
|
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...
|
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...
|
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...
|
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 :...
|
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...
|
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...
|
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...
|
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...
| |