while($ row = mysql_fetch_array($ query))在第二次不起作用 [英] while($row = mysql_fetch_array($query)) doesn't work in second time

问题描述

我有:

$query = mysql_query("SELECT ... ");
while($row = mysql_fetch_array($query)) { first time used; }
...
while($row = mysql_fetch_array($query)) { second time used; }

第二次不起作用.为什么?

In second time it doesn't work. Why?

推荐答案

这是因为内部数据指针已到达末尾.要重新读取查询，请使用mysql_data_seek()倒退指针，或重新发出查询.

That's because the internal data pointer has reached its end. To reread the query, either rewind the pointer with mysql_data_seek(), or reissue the query.

这篇关于while($ row = mysql_fetch_array($ query))在第二次不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！