I am just learning PHP/MySQL, so please forgive if this is a ridiculously lame question.
I have developed a small web app to simply display information from the database. The page will refresh itself every 60 seconds (plus the time it takes to perform the refresh itself). The data in the db is updated every 10 minutes. This arrangement runs fine until the page refresh happens during the database update. When that happens, it will display the 1st line for the html header <!DOCTYPE HTML PUBLIC and that it! I am dead in the water because the refresh meta-command in the html is not loaded. Being new, I wrote this very close to the book I was following and thought I had everything I need so PHP would generate an error message. But all I get is <!DOCTYPE HTML PUBLIC. Note the "die()" function in the code below. Also the showerror() function is basically a wrapper around a die() function I would appreciate any help as to why I am not getting an error message as well as any ideas as to the root problem. I suspect some type of db locking issue. Below is what I believe is the pertinent code. I am using EasyPHP 1-8 (for Windows) which is made up of : Apache 1.3.33 PHP 4.3.10 MySQL 4.1.9 ------------------------------------------------------------------------ -------- <!DOCTYPE HTML PUBLIC <?php require_once "HTML/Template/IT.php"; require "dbInb.inc"; // Connect to the MySql server if (!($connection = @ mysql_connect($hostname, $username, $password))) die("Cannot connect"); if (!(mysql_select_db($databaseName, $connection))) showerror(); // Create a new template, and specify that the template files are // in the subdirectory "templates" $template = new HTML_Template_IT("./templates"); // Load the template file $template->loadTemplatefile("Inbounds.tpl", true, true); // Run the OVERDUE query on the connection if (!($result = @ mysql_query("SELECT * FROM tblinbounds WHERE batch_in_id = (SELECT batch_in_id FROM tblbatch_in ORDER BY batch_in_id DESC LIMIT 1) AND ((del_date < DATE_FORMAT(NOW(), '%m/%d/%y')) OR (IsEmpty(del_date))) ORDER BY del_date, del_time", $connection))) showerror(); while ($row = mysql_fetch_array($result)) { // work with the record block $template->setCurrentBlock("OVERDUE"); // Assign the row data to the template placeholders $template->setVariable("VENDOR", $row["vendor"]); $template->setVariable("DESCRIPTION", $row["desc"]); $template->setVariable("CARRIER", $row["carrier"]); $template->setVariable("TRAILER", $row["trailer"]); $template->setVariable("DOCK", $row["dock"]); $template->setVariable("DELDATE", $row["del_date"]); $template->setVariable("DELTIME", $row["del_time"]); // Parse the current block $template->parseCurrentBlock(); } . . . . . (More blocks like the OVERDUE block above and that's it.) ********************** ** LEGAL DISCLAIMER ** ********************** This E-mail message and any attachments may contain legally privileged, confidential or proprietary information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this E-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this E-mail message from your computer.