<%
sqltext="select * from "&tablename1&" where sroot_usefulness=1 order by sroot_id"
rs.Open sqltext,db,1,1
m=1
colzs=5
rowzs=10
for j=1 to rowzsfor i=1 to colzs
if not rs.EOF then
.....输出内容response.write rs("id")rs.MoveNext //php里面没有这个啊
m=m+1
end if
nextnext
rs.Close
怎么转成php啊 php 里面没有for循环 刚转PHP 不太懂下面是我写的
*********************************************************** <?php
$sqltext7="select * from ".$tablename1." where sroot_usefulness=1 order by sroot_id" ;
echo $sqltext7;
$result7 = mysql_query($sqltext7);
$RS7 = mysql_fetch_array($result7);
$m=1;
$colzs=5;
$num = mysql_num_rows(mysql_query($sqltext7));
$rowzs=10;for ($j=1;$j<=$rowzs;$j++){for ($i=1;$i<=$colzs;$i++){while(!!$RS7){
....输出内容echo $RS7['id']...循环都是这一句...不变只有一条 就郁闷了!
$m=m+1;
}
}
}
老是输出的是第一条
?>
麻烦帮我转下啊 .....................谢谢
sqltext="select * from "&tablename1&" where sroot_usefulness=1 order by sroot_id"
rs.Open sqltext,db,1,1
m=1
colzs=5
rowzs=10
for j=1 to rowzsfor i=1 to colzs
if not rs.EOF then
.....输出内容response.write rs("id")rs.MoveNext //php里面没有这个啊
m=m+1
end if
nextnext
rs.Close
怎么转成php啊 php 里面没有for循环 刚转PHP 不太懂下面是我写的
*********************************************************** <?php
$sqltext7="select * from ".$tablename1." where sroot_usefulness=1 order by sroot_id" ;
echo $sqltext7;
$result7 = mysql_query($sqltext7);
$RS7 = mysql_fetch_array($result7);
$m=1;
$colzs=5;
$num = mysql_num_rows(mysql_query($sqltext7));
$rowzs=10;for ($j=1;$j<=$rowzs;$j++){for ($i=1;$i<=$colzs;$i++){while(!!$RS7){
....输出内容echo $RS7['id']...循环都是这一句...不变只有一条 就郁闷了!
$m=m+1;
}
}
}
老是输出的是第一条
?>
麻烦帮我转下啊 .....................谢谢
echo $sqltext7;
$result7 = mysql_query($sqltext7);
while($row = mysql_fetch_array($result7)){
foreach($row as $k=>$v){
echo $v;
}}php简单吧。
echo $sqltext7;
$result7 = mysql_query($sqltext7);
$RS7 = mysql_fetch_array($result7);$m=1;$colzs=5;
$num = mysql_num_rows(mysql_query($sqltext7));
$rowzs=10;for ($j=1;$j<=$rowzs;$j++){for ($i=1;$i<=$colzs;$i++){$RS7 = mysql_fetch_array($result7);
....输出内容echo $RS7['id'];!
$m=m+1;
}
}
}
echo $sqltext7;
$result7 = mysql_query($sqltext7);
$RS7 = mysql_fetch_array($result7);$m=1;
$colzs=5;
$num = mysql_num_rows(mysql_query($sqltext7));
$rowzs=10;for ($j=1;$j<=$rowzs;$j++){for ($i=1;$i<=$colzs;$i++){$RS7 = mysql_fetch_array($result7);
....输出内容$sqltext8="select * from ".$tablename2." where subs_pid=".$RS7['id']." and subs_usefulness=1 order by subs_id" ;
$result8 = mysql_query($sqltext8);
$RS8 = mysql_fetch_array($result8);
while(!!$RS8){
....输出内容}
$m=m+1;
}
}
} 红色部分 就成死循环了....
改成
if(!!$RS8){
....输出内容}改成if 只能输出一条 换成while 就成死循环了......郁闷啊求真相
$result8 = mysql_query($sqltext8);
while($RS8 = mysql_fetch_array($result8)) {....输出内容}
$RS8 = mysql_fetch_array($result8}
while($RS8){}跟
while($RS8 = mysql_fetch_array($result8)) {}
两个不一样
while($RS8){}跟
while($RS8 = mysql_fetch_array($result8)) {}
不一样 是为什么?
while($RS8){} //while 中没有对 $RS8 做任何改变,所以进去了就是死循环
while($RS8 = mysql_fetch_array($result8)) {}
每次从 $result8 中读取一个数组,由于 $result8 资源是有限的,所以总有读取完的时候。当 $RS8 为空的时候,循环结束