• Resolved abonne

    (@abonne)


    Hi,

    I am new to WordPress.

    We have an app that captures customer calls. Call info is stored in a different MYSQL DB, same WP server. On my blog, I have created a new page called “Outstanding calls” so it displays the results of a query from the customer calls DB.

    I have successfully created a PHP script that performs what I describe here ; it displays the results in a HTML table.

    Using the default theme, I customized page.php like so

    <?php
    /**
     * @package WordPress
     * @subpackage Default_Theme
     */
    
    get_header(); ?>
    <div id="content" class="narrowcolumn" role="main">
    <div class="post" id="post-<?php the_ID(); ?>">
    <h2><?php the_title(); ?><?php echo 'as of today, ' ;?><?php the_date(); ?></h2><br />        <?php wp_reset_query();
    if (is_page('What we are working on...')) {
                $con = mysql_connect("some_host", "some_username","some_password") ;
                if (!$con) {
                    die('Could not connect: ' . mysql_error());
                }
                mysql_select_db("some_db", $con) or die ("Couldn't select the database.");
                $result = mysql_query("select * from cases where status='Open' order by due_by asc");
                echo '<table id="mytable"><thead>
    <tr>
    <th>Request</th>
    <th>Requester</th>
    <th>Created On</th>
    <th>Due By</th>
    </tr></font></thead><tbody>';
                while($row = mysql_fetch_array($result)) {
                    echo '<tr><td id="mytd">'
                            . $row['request_title'] . '</td><td id="mytd">'
                            . $row['requester'] . '</td><td id="mytd">'
                            . $row['created_on'] . '</td><td id="mytd">'
                            . $row['due_by'] . '</td>'
                            . '</tr>';
                }
                echo '</tbody></table>';
                mysql_close($con);
    } ?>
        </div>
    </div>
    <?php get_sidebar(); ?>
    <?php get_footer(); ?>

    and it works great!

    Problem is that the page never refreshes! Ever! I run my PHP script from the command line and see new open cases. How can I make this page refresh? I tried using “wp_reset_query()” but it had no effect….

    Could it be because I am using permalinks?

    I welcome your input. Thanks,

    Al.

The topic ‘Page not refreshing…ever!’ is closed to new replies.