MySQL / PHP - Updated records not showing in source code

Discussion in 'MySQL' started by KatieK, Nov 24, 2007.

  1. #1
    I've got a MySQL database that I'm accessing using PHPMyAdmin. I've updated a few records in one of the tables, but the updated content isn't showing up on my web page. I've confirmed that this is occurring with a couple records, in fact.

    (I'm using PHP to set up a query, and submit and process that query through MySQL.) I've done a few COMMIT; commands in the SQL Query window, but that didn't help. If I go to edit that record again, the content is the updated version, but my web page still shows the old content.

    I'd appreciate any ideas. I fear I'm missing something simple. Thanks!
     
    KatieK, Nov 24, 2007 IP
  2. SolarCat

    SolarCat Active Member

    Messages:
    100
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    88
    #2
    You may be seeing cached content in your browser. Try doing a forced refresh of the page, which is Ctrl-F5 for IE and Firefox. If that doesn't work and you're using IE, you can clear all your locally cached content using the Tools menu, Internet Options/General/Browsing History/Settings.

    I hope this helps.

    Steve
     
    SolarCat, Nov 25, 2007 IP
  3. KatieK

    KatieK Active Member

    Messages:
    116
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Alas, clearing the cache does not do it. I even used the Dev Toolbar in FF to clear the cache.
     
    KatieK, Nov 25, 2007 IP
  4. SolarCat

    SolarCat Active Member

    Messages:
    100
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    88
    #4
    Hmm. I'm out of ideas. Silly question, but are you sure that the web page is getting generated dynamically from the database each time? There could possibly be some kind of server-side caching going on.
     
    SolarCat, Nov 25, 2007 IP
  5. KatieK

    KatieK Active Member

    Messages:
    116
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    58
    #5
    How could I check for server side caching?
     
    KatieK, Nov 25, 2007 IP
  6. SolarCat

    SolarCat Active Member

    Messages:
    100
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    88
    #6
    Server-side caching would be a deliberate feature of the framework you're using. If your site is based on a CMS, then a caching system may be built in. One that I know that has caching is Typo3. If you built the site yourself and didn't build in caching, then you don't have it unless you used some libraries that had it built in.

    Sorry if this is a little vague, but there are many ways that caching could be implemented.
     
    SolarCat, Nov 25, 2007 IP