If you don't want the whole page to refresh when you update, then you probably need to use AJAX with a timer event to call the PHP code that returns the updated record count. On the PHP side it could be as simple as doing a select query and returning a count. On the Javascript side you'll need to provide a call to your PHP using AJAX and if all you want back is a record count, you can get that with the text property rather than doing a whole XML transfer. Without writing the whole thing, your PHP could be as simple as:
// Set up MySql connection
$sql= "SELECT COUNT(*) FROM mytable WHERE Whatever = 'What Im looking for'";
$result = mysql_query($sql) or die("Sorry, you screwed up!");
echo mysql_num_rows($result);
Here's an example of doing the stuff based on a timer event in Javascript[^]. You'd put your function to do the update call as the argument to the timer. To handle the AJAX, take a look at this PHP AJAX tutorial[^]. You put your own Javascript code to handle the return and update your label as required.
CQ de W5ALT
Walt Fair, Jr., P. E. Comport Computing Specializing in Technical Engineering Software
