一个简单的
$stuff = mysql_query("SELECT * FROM users");
while($s = mysql_fetch_array($stuff)){
# ....
}
while($r = mysql_fetch_array($stuff)){
# ...
}
最后的while()不起作用。我尝试过运行foreach(以$s身份运行$stuff),但是得到了无效的数组错误。
如何使用同一查询两次?
发布于 2011-11-27 20:33:42
$stuff = mysql_query("SELECT * FROM users");
while($s = mysql_fetch_array($stuff)){
# ....
}
// add this line
mysql_data_seek( $stuff, 0 );
while($r = mysql_fetch_array($stuff)){
# ...
}
应该能起到作用
当然,另一种方法是将结果存储在数组中并重用该数组
发布于 2015-04-30 17:18:29
如果您使用"foreach“而不是"while”,则不会有任何问题,也不需要使用mysqli_seek_data():
//1st loop :
foreach($stuff as $row)
{
echo $row['...'];
}
...
//2nd loop :
foreach($stuff as $row)
{
echo $row['...'];
}
https://stackoverflow.com/questions/8285557
复制相似问题