表格输出mysql内容不行 请帮忙看看有什么有关问题 多谢各位
表格输出mysql内容不行 请帮忙看看有什么问题 谢谢各位!
<?php
$dbconn=mysql_connect("localhost", "root","");
$sqlname="ms_qua";
mysql_select_db($sqlname,$dbconn);
session_start();
?>
<div style="margin:0 auto; width:100%; padding-top:10px;">
<b class="tableTitle">表名:厂家资质信息</b><br />
</div>
<table width="100%" border="1">
<thead>
<th width="15">序号</td>
<th width="100">部门</td>
<th width="80">岗位</td>
<th width="50">姓名</td>
<th width="90">身份证号码</td>
<th width="70">合同签订时间</td>
<th width="200">证书名称</td>
<th width="130">发证单位</td>
<th width="130">证书编号</td>
<th width="70">发证日期</td>
</thead>
<?php
$sql = "SELECT * FROM tables where qua='ms_qua' order by TABLE_NAME";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result))
{
//print_r($row);
?>
<tr>
<td align="center"><b><?php echo $row['id'];?></b></td>
<td><?php echo $row['bumen']; ?></td>
<td><?php echo $row['gangwei'] ;?></td>
<td align="center"><?php echo $row['xingming']; ?></td>
<td align="center"><?php echo $row['shenfenzheng']; ?></td>
<td><?php echo $row['hetongqianding']; ?></td>
<td><?php echo $row['zhengshumingcheng']; ?></td>
<td><?php echo $row['fazhengdanwei']; ?></td>
<td><?php echo $row['zhengshubianhao']; ?></td>
<td><?php echo $row['fazhengriqi']; ?></td>
</tr>
<?php
}
mysql_close($dbconn);
?>
</table>
------解决思路----------------------
把错误输出打开,比如error_reporting(E_ALL);
<?php
$dbconn=mysql_connect("localhost", "root","");
$sqlname="ms_qua";
mysql_select_db($sqlname,$dbconn);
session_start();
?>
<div style="margin:0 auto; width:100%; padding-top:10px;">
<b class="tableTitle">表名:厂家资质信息</b><br />
</div>
<table width="100%" border="1">
<thead>
<th width="15">序号</td>
<th width="100">部门</td>
<th width="80">岗位</td>
<th width="50">姓名</td>
<th width="90">身份证号码</td>
<th width="70">合同签订时间</td>
<th width="200">证书名称</td>
<th width="130">发证单位</td>
<th width="130">证书编号</td>
<th width="70">发证日期</td>
</thead>
<?php
$sql = "SELECT * FROM tables where qua='ms_qua' order by TABLE_NAME";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result))
{
//print_r($row);
?>
<tr>
<td align="center"><b><?php echo $row['id'];?></b></td>
<td><?php echo $row['bumen']; ?></td>
<td><?php echo $row['gangwei'] ;?></td>
<td align="center"><?php echo $row['xingming']; ?></td>
<td align="center"><?php echo $row['shenfenzheng']; ?></td>
<td><?php echo $row['hetongqianding']; ?></td>
<td><?php echo $row['zhengshumingcheng']; ?></td>
<td><?php echo $row['fazhengdanwei']; ?></td>
<td><?php echo $row['zhengshubianhao']; ?></td>
<td><?php echo $row['fazhengriqi']; ?></td>
</tr>
<?php
}
mysql_close($dbconn);
?>
</table>
------解决思路----------------------
把错误输出打开,比如error_reporting(E_ALL);