php查询有关问题_PHP

php查询问题

<form id="changjiachaxun" name="changjiachaxun" action="changjiachaxun.php" method="post" >
<div id="srygxm">输入员工姓名<input type="text" value="" name="xingming"></div>
<div id="chajiachaxunbutton"><input name="submit" type="submit" value="查询"></div>
</form>

<?php

  $link=mysql_connect("localhost", "root","");
  $db  = mysql_select_db("ms_qua");
  mysql_query("set names 'utf8'");

  ?>
  <div style="margin:0 auto; width:100%; padding-top:10px;">
<b class="tableTitle"><a id="a">表名:厂家资质信息</a></b><br />
</div>
  <table width="100%" border="1">
<tr class="biaotou">
  <td width="45">序号</td>
  <td width="110">部门</td>
  <td width="80">岗位</td>
  <td width="50">姓名</td>
  <td width="90">身份证号码</td>
  <td width="110">合同签订时间</td>
  <td width="200">证书名称</td>
  <td width="130">发证单位</td>
  <td width="60">证书编号</td>
  <td width="70">发证日期</td>
</tr>
<?php
if (isset($_POST['submit'])){
$xingming=$_POST['xingming'];
$sql="SELECT * FROM qua WHERE xingming=".$xingming."";
$query=mysql_query($sql);
while($row=mysql_fetch_row($query))
{

echo '<tr>';
foreach($row as $v)
echo "<td>$v</td>";
        echo '</tr>';
}
}
?>
求帮助查询这个弄好几天了还是出不来= =
------解决思路----------------------
php 不是告诉你有错吗？

$sql="SELECT * FROM qua WHERE xingming='$xingming'";
$query=mysql_query($sql) or die(mysql_error());