how to display leave notification of users on admin dashboard after clicking on that it will removed from that list in php
<p>how to display leave notification of users on admin dashboard after clicking on that it will removed from that list in php the code is below </p>

<pre><code>enter code here

&lt;?php    
if(!empty($_REQUEST['view']))
{
include("connection.php");
    $z="update leave set view='$v'";
    mysql_query($z);
}
</code></pre>

<p>?></p>

<pre><code> &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
 &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
 &lt;head&gt;
 &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;
&lt;title&gt;Welcome&lt;/title&gt;
</code></pre>

<p>
     
    </p>

<pre><code> &lt;div align="center"&gt;
 &lt;table&gt;
&lt;?php 
include("connection.php");
$q="SELECT * FROM  `leave` ,users where users.sr_no=leave.user_id and view=0";
$res=mysql_query($q);
while($row=mysql_fetch_assoc($res))  
{?&gt; 
 &lt;tr&gt;&lt;a href="edit_leave.php?edid=&lt;?php echo $row['srno']; ?&gt;"&gt;&lt;?php echo    $row['name']."&lt;/br&gt;";?&gt;&lt;/a&gt;&lt;/tr&gt;
 &lt;?php 
}
  $v=$_REQUEST['view'];
 ?&gt;

 &lt;/table&gt;

&lt;/div&gt;

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