Monitor Change in MySQL DataBase
<p>So , i have a MySQL DataBase , from my Html/Php Page , i can Access it and read somes Values and show it in the web Page , </p>

<p>my Problem :</p>

<p>On the other side , an Android App will also Modify the DataBase , and somes Values , so i have to click on Refresh Button from the Web Browser where the Data are Shown ,</p>

<p>Is there any way to constantly Monitor the DataBase for any Changes on a special Row for example , then Update it on the Html Page , i tried this Code with no Luck :</p>

<pre><code>&lt;?php
 session_start();
 $One=$_SESSION['One']; 
 $Two=$_SESSION['Two'];  
 $Three=$_SESSION['Three']; 
 $Four=$_SESSION['Four']; 
 $tbl_name =$_SESSION['Five']; 
 // Connect to server and select databse.
 mysql_connect("$One", "$Two", "$Three")or die("cannot connect"); 
 mysql_select_db("$Four")or die("cannot select DB");
 $q=mysql_query("SELECT message FROM $tbl_name WHERE pass='".$_SESSION['pass']."'");

 while($row = mysql_fetch_array($q)){

 }
while(true!=false)
 echo $row['message'];
 ?&gt;
 &lt;head&gt;
 &lt;html&gt;
 &lt;body&gt;


&lt;title&gt;Title&lt;/title&gt;
&lt;div&gt;&lt;h2&gt;&lt;?php echo 'I found something in the session: ' .$_SESSION['text']?&gt;&lt;/h2&gt;   &lt;/div&gt;
 &lt;/br&gt;
 &lt;/br&gt;


 &lt;/body&gt;
 &lt;/html&gt;
 &lt;/head&gt;
</code></pre>
