UC知道php 循环问题
来源：百度知道 编辑：UC知道 时间：2024/07/04 07:33:21
<?php
$exec="select * from sdb_orders where disabled='false' order by order_id desc";
$result=mysql_query($exec);
$row=mysql_fetch_row($result);
while($row){
//继承数据;
$sql=mysql_query("select * from egg_cps where ip='".$row[19]."' and zt=0 order by id desc");
if (mysql_query($sql)){
while($row1=mysql_fetch_row($sql))
{
?>
<script language="javascript" src="http://a.eoeogoo.com/cs/index.asp?otime=<?php echo "".$row1[5]."" ?>&o_cd=<?php echo "".$row[0]."" ?>&m_id=eoeogoo&u_id=<?php echo "".$row1[1]."" ?>&p_cd=0&it_cnt=<?php echo "".$row[14]."" ?>&price=<?php echo "".$row[28]."" ?>&comm=<?php echo "".($row[28]*0.16).""; ?
$exec="select * from sdb_orders where disabled='false' order by order_id desc";
$result=mysql_query($exec);
$row=mysql_fetch_row($result);
while($row){
//继承数据;
$sql=mysql_query("select * from egg_cps where ip='".$row[19]."' and zt=0 order by id desc");
if (mysql_query($sql)){
while($row1=mysql_fetch_row($sql))
{
?>
<script language="javascript" src="http://a.eoeogoo.com/cs/index.asp?otime=<?php echo "".$row1[5]."" ?>&o_cd=<?php echo "".$row[0]."" ?>&m_id=eoeogoo&u_id=<?php echo "".$row1[1]."" ?>&p_cd=0&it_cnt=<?php echo "".$row[14]."" ?>&price=<?php echo "".$row[28]."" ?>&comm=<?php echo "".($row[28]*0.16).""; ?
$row=mysql_fetch_row($result);
while($row){
改成
while($row=mysql_fetch_row($result))
原因是mysql_fetch_row每次只从结果集中返回一行，所以$row的值在非空的情况下，while($row)会变成死循环
mysql_fetch_row($sql)
参数错了！！！ 参数是结果集（resource ），不是（string）