数据读取错误
conn.php
<?php
$conn=mysql_connect("localhost","mlstudio","ml902975");
mysql_select_db("db_bcty365",$conn);
mysql_query("set names gb2312");
?>
显示页面代码
<table width="220" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="220" height="260" class="b">
<tr valign="top">
<td height="38" bgcolor="#FFFFFF">
<table width="200" height="22" border="0" align="center" cellpadding="0" cellspacing="0">
<?php
$sqluwz=mysql_query("select * from tb_soft order by addtime desc limit 0,7",$conn);
$infouwz=mysql_fetch_array($sqluwz);
if($infouwz==false){
?>
<tr>
<td width="20" height="22"><div align="center"><img src="images/mark_0.gif" width="3" height="3" /></div></td>
<td width="180"> 暂无软件提供下载!</td>
</tr>
<?php
}else{
$i=1;
do{
?>
<tr>
<td width="20" height="22"><div align="center"><img src="images/mark_0.gif" width="3" height="3" /></div></td>
<td width="180" height="22" style="padding:5">
<a href="softinfo.php?id=<?php echo $infouwz["id"];?>" class="a1">
<?php
if($i==1)
{
echo "<font color=red>";
}
echo unhtml(msubstr($infouwz["softname"],0,16));
if(strlen($infouwz["softname"])>16)
{
echo " .";
}
echo "<font color=red>[".substr(str_replace("-","/",$infouwz[addtime]),0,10)."]</font>";
if($i==1)
{
echo "</font>";
}
?>
</a>
</td>
</tr>
<tr>
<td height="1" colspan="2" background="images/line_1.gif"></td>
</tr>
<?php
$i++;
}while($infouwz=mysql_fetch_array($sqluwz));
}
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
网页提示错误
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ……
------解决方案--------------------
你要明白 do....while结构。。。这个不管条件是否成立,都会循环一次。
建议改成:
while($infouwz=mysql_fetch_array($sqluwz))
{
//do something here....
}
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource …… 报这样的错误,你就得在mysql_query($sql