Page not refreshing…ever!
-
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.