php+mysql : how to read several time results of query

Question

我在我的数据库上执行查询，我需要多次读取结果。我写了这个:

$result = mysql_query("SELECT field1, field2 FROM table WHERE true");
foreach ($my_array as $current) {
    //iterate over mysql resutls
    while ($current_row = mysql_fetch_array($result)) {                
        //do something
    }
}

现在，当我第一次读取查询的所有行时，我如何才能再次开始第一行以进行下一次 foreach 迭代？

Answer 1

你可以这样做

$result = mysql_query("SELECT field1, field2 FROM table WHERE true");
foreach ($my_array as $current) {
    //iterate over mysql resutls
    while ($current_row = mysql_fetch_array($result)) {                
        //do something
    }
}

mysql_data_seek($result,0);

然后继续循环!!

http://in3.php.net/mysql_data_seek