Question

This question already has an answer here:

Possible Duplicate:
How to reset mysql pointer back to the first row in PHP?

我在PHP书中有2处,处理一个数据库的数据清单。

$results = mysql_query("SELECT * FROM myTable");
while ($result = mysql_fetch_object($results))  {
    // do stuff
}

reset($results);
while ($result = mysql_fetch_object($results))  {
    // do some more stuff
}

然而,重新定位功能并没有在我的SQL资源范围内重新确定我的协调人。事实上,它产生了一个错误:

"Warning: reset() [function.reset]: Passed variable is not an array or object in /home/cs179_team13/public_html/timeTests/results.php on line 133."

Why? How do I reset a PHP pointer for a MySQL resource?

Answer 1

您可使用<代码>mysql_data_seek。

bool mysql_data_seek (resource$result , int$row_ number

更多信息可在。

Answer 2

You don t need such an ugly way.
Just get yourself an array.

$data = sql_to_arr("SELECT * FROM myTable");
foreach ($data as $row)  {
    // do stuff
}
foreach ($data as $row)  {
    // do stuff
}
foreach ($data as $row)  {
    // do stuff
}

this is way more convenient way to deal with data

Answer 3

页: 1

mysql_data_seek($resultset, 0) ;//reset result set

友情链接