注册 登录
编程论坛 PHP技术论坛

请问:这两句PHP语句有何问题?$myrow = mysql_fetch_array($rs)

qiangzai8536 发布于 2007-03-10 18:23, 1623 次点击

<?
$rs=mysql_query("SELECT * FROM dyxx WHERE zhushi='tzsc_vip' order by rq desc limit $offset,$pagesize");
$myrow = mysql_fetch_array($rs);
while ($myrow = mysql_fetch_array($rs))
{
echo "
<tr>
<td width='450' height='25'><font color='#EF8818'>※</font><a class='wb' href='nr.php?action=bt&id=".$id."'>".$myrow['title']."</a></td>
<td width='120' height='25' align='center'>".$myrow['rq']."</td>
</tr>";
}
?>

返回说这两句有问题:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\myweb\tzsc.php on line 23
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\myweb\tzsc.php on line 24
即这两句:
$myrow = mysql_fetch_array($rs);
while ($myrow = mysql_fetch_array($rs))

注:zhushi字段是我后来在phpmyadmin中加的,其内容tzsc_vip也是直接在phpmyadmin中原来的信息后加入的,这样应该也是可以的吧?跟这会有关系吗?我觉得可能是语法上的问题,但不知在哪?请赐教!非常感谢!

2 回复
#2
rainic2007-03-10 19:58
$rs不是一个有效的结果资源

我看不出来哪错了

[此贴子已经被作者于2007-3-10 19:58:41编辑过]

#3
qiangzai85362007-03-11 14:28
哦,知道了,搞定!哈哈多谢!!
1