Problem with Mysql Query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JB
    #1

    Problem with Mysql Query

    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("UP DATE 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
    Tags: None
    • Tim Van Wassenhove
      #2
      Re: Problem with Mysql Query

      On 2004-01-13, JB <jeanbaptiste_i snardon@yahoo.f r> wrote:[color=blue]
      > 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("UP DATE 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?[/color]

      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

        Comment

        • Christopher Johnson
          #3
          Re: Problem with Mysql Query

          session_cache_l imiter('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" <jeanbaptiste_i snardon@yahoo.f r> wrote in message
          news:477bc493.0 401130957.3ebcd 807@posting.goo gle.com...[color=blue]
          > 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("UP DATE 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[/color]


            Comment

            • JB
              #4
              Re: Problem with Mysql Query

              Thank you very much!

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




              "Christophe r Johnson" <christopher-johnson@augusta na.edu> wrote in message news:<09XMb.453 31$I06.281343@a ttbi_s01>...[color=blue]
              > session_cache_l imiter('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" <jeanbaptiste_i snardon@yahoo.f r> wrote in message
              > news:477bc493.0 401130957.3ebcd 807@posting.goo gle.com...[color=green]
              > > 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("UP DATE 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[/color][/color]

                Comment

                Previous template Next
                Working...