AJAX and a standard PM type system. HTTP itself is incapable of providing a non-static environment, so timed refreshes and AJAX is your only option.
As of PHP 5.5, the MySQL library has been officially deprecated. It is recommended to move to either MySQLi or PDO libraries for your mysql connectivity. See here for help choosing which interface you prefer: http://php.net/manual/en/mysqlinfo.api.choosing.php