修改MYSQL数据库

?php
$link=mysql_connect("localhost","root","123");
mysql_select_db("ylzou",$link);
$q = "SELECT * FROM pc";
mysql_query("SET NAMES GB2312");
$rs = mysql_query($q,$link);
#if(!$rs){die("Valid result!");}
echo "";
echo "
    ename
    PCname
    ";
while($row = mysql_fetch_row($rs))
    echo "
    modify
    $row[0]
    $row[1]     
   ";
echo "";
mysql_free_result($rs);
?>


?php
$link =mysql_connect("localhost","root","123");
if(!$link){die("error");}
echo "faile";
mysql_select_db("ylzou", $link);
$del_id=$_GET["ename"];
$q="select * from pc where ename='$del_id'";
mysql_query("SET NAMES GB2312"); $rs = mysql_query($q, $link);
if(!$rs){die("faile");}
?>
html>
head>
/head>
body>
form action="modify_finish.php" method="POST">
?php
echo "";
while($row = mysql_fetch_object($rs)) echo "pcname'>";
mysql_close($link); ?>
input type="submit" name="submit" value="submit">
/form>
/body>
/html>


?php
$link =mysql_connect("localhost","root","123");
if(!$link){die("error");}
echo "连接成功";
mysql_select_db("ylzou", $link);
$exec="update pc set pcname='".$_POST['pcname']."' where ename=".$_POST['ename']."";
echo "修改成功" ;
mysql_close($link)