I want to display the last update time & date whenever MySQL tables were updated with the latest changes, I got the below PHP code working in PHP 5 but not the latest version PHP 7 and return an error showing nothing on the web page, trying to fix it but no avail, anyone got any idea what went wrong?
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("information_schema") or die(mysql_error());
$query1 = "SELECT 'UPDATE_TIME' FROM 'TABLES' WHERE 'TABLE_SCHEMA' LIKE 'demo' AND 'TABLE_NAME' LIKE 'usc'";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1)) {
echo "<font color='red'> (Last update : ".$row['UPDATE_TIME'].")</font>";