Update ข้อมูลโดยการคลิกปุ่ม มีวิธีที่ทำการอัพเดทข้อมูลผ่านการคลิกปุ่มไหมครับ ประมาณว่าเปลี่ยนสถานะจาก 1 เป็น 2 ในฐานข้อมูล

      <table  border=1 align="center" / >
<tr bgcolor='#3399FF'><th height="30" valign="top" bgcolor="#99CCFF">ID</th>
<th width="160" bgcolor="#99CCFF">Name</th>
<th width="133" bgcolor="#99CCFF">Company	</th>
<th width="150" bgcolor="#99CCFF">Position	</th>
<th width="111" bgcolor="#99CCFF">Mobile Phone</th>
<th width="233" bgcolor="#99CCFF">E-mail </th>
<th width="auto" bgcolor="#99CCFF">Check </th>

</tr>   
<p>
  <?
  $sql="select  * from member where name like '%".$_GET["txtKeyword1"]."%' || surname like '%".$_GET["txtKeyword1"]."%' || company like '%".$_GET[txtKeyword1]."%' || position like '%".$_GET[txtKeyword1]."%'   order by id asc  ";
	//$sql = "SELECT * FROM pipe_detail where id order by acc_company  asc ";
$result=mysql_db_query($dbname,$sql);
$x=1;
	while($row=mysql_fetch_array($result))

	{
				
echo"<td>",$x,"</td>";
$id = $row['id'];
															echo"<td>",$row["name" ]."   ". $row["surname"],"<center/></a></td>";
															echo"<td>",$row["company"],"</td>";
															echo"<td>",$row["position"],"</td>";
															echo"<td>",$row["mobile"],"</td>";
															echo"<td>",$row["email"],"</td>";
															//echo $row["add"];
															if ($row["add"] == "y"){
															echo"<td><a href=\"save_edit.php? id=$id &f=1\">
															<center/><img src=\"image/yep.png \" ></a><input name = 'add' type='hidden' value='n'></td>";}
															else if ($row["add"] == "n" || " ") {
															echo"<td><a href=\"save_edit.php? id=$id &f=2\">
															<center/><img  src=\"image/delete.gif \" ></a><input name = 'add' type='hidden' value='y'></td>";}
																										
																					
															echo"</tr>";
															
															

$x++;
				}

	
?>
</p>
</table>

 <?php
 $f=$_GET['f'];
 $id=$_GET[id];
 $add=$_GET[add];
include "connect.php";
$sql="select * from member where name='$name'";
$result=mysql_db_query($dbname,$sql);
if ($f == '2'){
	$sql="UPDATE member SET add = 'y' where id=$id  ";
		echo "Activate Successfully !";
		echo '<meta http-equiv="refresh" content="1;url=member.php">'; }
		else if($f=='1') {
		$sql="UPDATE member SET add = 'n'  where id=$id  ";
		//$db_query=mysql_db_query("sales",$sql);
		echo "Activate Successfully !";
		echo '<meta http-equiv="refresh" content="1;url=member.php">'; }
mysql_close();
	?>	

//$db_query=mysql_db_query("sales",$sql);

$db_query=mysql_query($sql) or die(mysql_error());