PHP Message Board Content Deletion code

<meta http-equiv= "Content-type" content= "HTML; Charset=utf-8 "/>


<?php


$lianjie = mysql_connect ("localhost", "root", "Xiaolie") or Die ("Connection failed");


mysql_query ("Set names UTF8");


if ($lianjie)


{


mysql_select_db ("Xiaolie");


if ($_get)


 {


$a = $_get["id"];


$sc = "Delete from zhuce where id= $a";


$fasong = mysql_query ($SC) or Die (Mysql_error ());


if ($fasong)


echo "Record has been successfully deleted <a href=sc_my.php> continue to delete record </a>";


Else


echo "Delete record failed <br><a href=sc_my.php> return </a>";


   


  


 }


Else


 {


$fasong = mysql_query ("SELECT * from Zhuce") or Die (Mysql_error ());


echo "<table border=1>


<tr>


<td> numbering </td>


<td> user name </td>


<td> Gender </td>


<td> Age </td>


<td> Registration Time </td>


<td> Operations </td>


</tr> ";


while ($nr = Mysql_fetch_array ($fasong))


  {


echo "<tr>


<td> ". $nr [id]." </td>


<td> ". $nr [" name]. " </td>


<td> ". $nr [" Xingbie "]." </td>


<td> ". $nr [" nianling "]." </td>


<td> ". $nr [" Zc_shijian "]." </td>


<td><a href=sc_my.php?id= ". $nr [id]." > Delete </a></td>


</tr> ";


  }


echo "</table>";


 }


}


?>